The above example will put an e-mail message to "ToJohn@doe.com" into your Outbox. To have the e-mail send window pop up, change the last parameter to "True". To send to more addresses, separate the addresses with a semicolon.
Here's another example that shows where to put CC and Bcc addresses:
The "acFormatRTF" parameter will send the report output in a format that can be read by MS Word. You can also use:
"acFormatHTML" - Your sent report output will be opened with a web browser.
"acFormatTXT" - Your sent report output will be opened with notepad, or wordpad.
E-MAIL AN ATTACHMENT
To include an attachment with your e-mail, you need to use automation and MS Outlook or some other third-party e-mail software because the SendObject method doesn't have the ability to include an attached file.
A subroutine you can use to send an e-mail message with an attachment through MS Outlook is here. Please note that a reference to Outlook is required.