Getting an access report in the message body of an email

K

Kellie

How can I get my report included in the message body of my email instead of
an attachment. I currently have a macro set up with SendObject but I don't
want the report as an attachment
 
T

Tony Toews

Kellie said:
How can I get my report included in the message body of my email instead of
an attachment. I currently have a macro set up with SendObject but I don't
want the report as an attachment
Click to expand...

One of the links at the Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm explains how to do this.
Note that this requires VBA code.

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
 
K

Kellie

Thanks for your reply
There was a similar question later on the 29th from Josh called 'RE: sending
a form using outlook with the data in the body of the email'
The code that Neil gave helped me perfectly (I used the data from my Form
rather than using the Report)
 
Top