Copy report, or query to body of Email.

[lakers8175]

Is there a way to copy a report, query to an outlook email? I don't want to attach it I want to put it on the body of the email. I'm using Access97 and Outlook2000.

Sean

 

[scking]

As your requirement states I don't believe their is anything to embed a report in the middle of an email unless possible you use OLE to embed a Snapshot object in a Word document used for the email message. For a query you can simply recreate the SQL code using something like CurrentDb.QueryDefs("qryArticles&quot.SQL and concatenate it to the body text you will be using for the email.
----------------------
scking@arinc.com
Life is filled with lessons.
We are responsible for the
results of the quizzes.
-----------------------