Automate Emailing an Access Report through Outlook (1 Viewer)

[jdp103]

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?

 

[FoFa]

DoCmd.SendObject acSendReport, "Main_Report", acFormatRTF, "You@Domain.com", , , "Report Title", "See attached File", False

 

[jdp103]

Worked BEAUTIFULLY! THANK YOU!!!