MS Access to Email Help

[rivergum_23]

Hi All,
I have a MS Access project here that grabs the email address from the form and emails through Outlook, which works perfectly. What I require help with is that I would like to insert the contents of the report into the body of the email. So basically run the report, insert the content of the report in the body of the email and send. I'm not really sure how to get the data from the report into the body of the email.

Any help always appreciated.

Cheers,


River

[orange]

I suggest you use Google to find related posts. Often people want to attach reports to emails.
I used this in Google "access to outlook with report in main body"

I don't think you can just copy a report as an email body, but I haven't tried it myself.

Here is a link that may get you started.
http://database.ittoolbox.com/groups...outlook-517058

[rivergum_23]

Hi Orange,
Thanks for the link.. Got the information I required.

Cheers,
River