How do you add the data from a report to the body of an e-mail.

[tyewing]

I'm trying to add the fields in an Access report to the body of an e-mail instead of using the snapshot viewer and using an attachment... Does anyone know how to do this?

Thanks in advance.

 

[dhookom]

What does the report have to do with the email? Why use the report at all if you don't want to use it all as an attachment?

Duane
Hook'D on Access
MS Access MVP

 

[tyewing]

A little history may help answer this.

I setup a macro in Access to automatically generate the report and send it as an attachment via Outlook e-mail. The managers that review this report do not want to have to open the attachment in the e-mail because they say that this slows them down. However, they would like to see the report data on the body of that e-mail instead. The attachment is set as HTML and includes a hyperlink and a picture (Not working) on the e-mails body.

Any suggestions on how to handle this?

 

[dhookom]

I would probably write some code with Outlook automation that would generate the body of the email. The code would duplicate the report layout as much as possible. There are probably lots of resources on the web regarding Outlook automation.

Duane
Hook'D on Access
MS Access MVP

 

[kjv1611]

Here's at least a start:

http://www.blueclaw-db.com/access_email_send_outlook.htm

And if you can't get the thing going the way you want, there are add-ins that can be purchased to get the job done as well.

--

"If to err is human, then I must be some kind of human!" -Me

 

[tyewing]

Thank you. I will give it a try.

Ty