Getting an access report in the message body of an email

[Guest]

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

 

[Tony Toews]

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

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

 

[Guest]

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)