How do I send a Query result in an email body (NOT attachment)?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access 2003 (Cross-Tab) Query result I need to send within an
(Outlook or OE) email BODY.

The DoCmd.SendObject will only export it as an attachment and I don't want
to use an html template (not too sure if that works either!).

Hope someone can help!
Cheers,
John
 
John said:
I have an Access 2003 (Cross-Tab) Query result I need to send within
an (Outlook or OE) email BODY.

The DoCmd.SendObject will only export it as an attachment and I don't
want to use an html template (not too sure if that works either!).

Hope someone can help!
Cheers,
John
Click to expand...

You could open a RecordSet against the query and then loop through it in code
appending each row into a string variable which you then add to the message
body.
 
If all you want is the data::

Highlight what you want.
Press Control-C
Click where you want it in your message
Press Control-V

If the format isn't right, paste first into Notepad and take it from there.

Alan
 
Back
Top