Automate Emailing an Access Report through Outlook

jdp103

Registered User.
Local time
Today, 04:46
Joined
Sep 26, 2003
Messages
46
I have a report in my access db that I would like to just click a button and have it automatically send to a user. I am new to VB and can't figure out the code to do it. Can anyone help? :confused:
 
DoCmd.SendObject acSendReport, "Main_Report", acFormatRTF, "You@Domain.com", , , "Report Title", "See attached File", False
 
Worked BEAUTIFULLY! THANK YOU!!!
 

Users who are viewing this thread

Back
Top Bottom