Email a Report

B

bbddvv

When i run a report, i would like it to automatically create an email (using
Outlook 2003) that includes the report (either as a PDF attachment or in the
body of the email) and also includes a predetermined message.

How do I do this?
 
B

bbddvv

Unfortunatly no, I wanted the email's body to be populated by the report
data. I wanted to avoid the whole attachment thing. Any other ideas?
 
E

etarhan

In your first message you mentioned a pdf attachment but in your reply to
martyn's suggestion you seem to have changed your mind about attachments,
which makes it confusing.

Without knowing what is in the report you want to e-mail, I would suggest
that you output the report in say, txt format and then read it back into a
string variable and use it for the "message body" parameter in the
sendobject command. Would it do?

Good Luck,
Engin Tarhan
 
T

Tony Toews

bbddvv said:
Unfortunatly no, I wanted the email's body to be populated by the report
data. I wanted to avoid the whole attachment thing. Any other ideas?
Click to expand...

To create a formatted document to send as an email you will need to
use VBA code to create a largish string. This string will then be
passed to the SendObject command as the body of the email. For more
details including sample air code see my Tips page on this topic at
http://www.granite.ab.ca/access/email/formatted.htm.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top