(dhl) I am using Access 2K. I run a report every week that shows over
due purchasing order. Each record in this report has the supplier and
their E-Mail address as fields. What I would like to do is when I run
the report for each over due PO send an e-mail to the supplier with
the PO information asking for an update. How can I do this? Thanks
for all your help.
David.

"David" <AirDavid_98 (AT) Yahoo (DOT) Com> wrote

SEND AN E-MAIL MESSAGE FROM ACCESS

It's simple! I just learned how to do it, and I thought I'd share it with
you. You need an e-mail program that uses MAPI, like Outlook Express:

DoCmd.SendObject ,,,"ToJohn (AT) doe (DOT) com",,,"Subject","Message",False

The above example will put an e-mail message to "ToJohn (AT) doe (DOT) 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 (AT) doe (DOT) com;ToBill (AT) doe (DOT) com","CcMary (AT) doe (DOT) com"
,"BccSue (AT) doe (DOT) com" , "Subject", "Message", False

E-MAIL THE OUTPUT OF A REPORT FROM ACCESS

Here's an example of how to send the output of a report named "Sales By
Order" via e-mail. If your report prompts you for parameters, you will be
prompted for them when you run this command:

DoCmd.SendObject acSendReport, "Sales By Order", acFormatRTF,
"ToJohn (AT) doe (DOT) 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

To include an attachment with your e-mail, you need to use automation
because SendObject won't do this. Here's how to use automation to send an
e-mail attachment:
http://support.microsoft.com/support.../q209/9/48.asp

Hope this helps,


--
Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com