Peter's Software
Helping you create better Microsoft Access applications

Send an E-Mail Message from MS Access

It's easy! You need an e-mail program that uses MAPI, like Outlook Express. Put this code in a command button OnClick event procedure:

DoCmd.SendObject _
    , _
    , _
    , _
    "ToJohn@doe.com", _
    , _
    , _
    "Subject", _
    "Message", _
    False

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:

DoCmd.SendObject _
    , _
    , _
    , _
    "ToJohn@doe.com;ToBill@doe.com", _
    "CcMary@doe.com", _
    "BccSue@doe.com", _
    "Subject", _
    "Message", _
    False

E-MAIL THE OUTPUT OF A REPORT FROM ACCESS

DoCmd.SendObject _
    acSendReport, _
    "Sales By Order", _
    acFormatRTF, _
    "ToJohn@doe.com", _
    , _
    , _
    "Subject", _
    "Message", _
    False

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