Automatic Email in Access

[RWatson1]

Hello,

I am working on setting Access to distribute reports via emails automatically at specific times. I created a macro and set scheduler for this function. The problem is the macro opens Outlook, adds the report in a PDF file but I have to select Send to distribute the report. I guess I need help to automtcaily Send the data. Any help is greatly appreciated.

 

[pr2-eugin]

Check the argument of the DoCmd.SendObject, it should say EditMessage set that to False.

 

[RWatson1]

Thank you! That solved it! I appreciate the help!

 

[pr2-eugin]

You're welcome !