How do I email a report as pdf, snapshot, or xml

[Chew407]

I need a report to be automatically emailed after it is generated by a report generator. I'd like a command button that, when clicked opens a Microsoft Outlook email window with the report as an attachment. I have searched the FAQs for an answer but only found a solution for COBOL. Anyone have a solution?

Thanks.

Chew

 

[ByteMyzer]

Wow, I didn't even know that Microsoft Access ran in COBOL...

 

[Chew407]

Lol. Sorry I wasn't saying that Access is running in COBOL. I searched the FAQs but found nothing for emailing reports in Access. There was only something about emailing reports in COBOL.

 

[ByteMyzer]

You can use the SendObject method (ref:

http://msdn.microsoft.com/en-us/library/aa220736(office.11).aspx)

For example:

DoCmd.SendObject acSendReport, _
    "MyReport", _
    acFormatRTF, _
    "ToReceipient@mymail.com", , , _
    "Test Subject", , True

 

[Chew407]

Wow! That was surprisingly easy! Thanks so much ByteMyzer.

Chew

 

[ByteMyzer]

You're welcome, I'm glad it worked for you