imbed query result into email..

[Guest]

is there a way to imbed (rather than attach) query results into an email with
vba? I'd like to keep the formatting of the datasheet grid, etc..if possible.
Thanks!
Don

 

[Arvin Meyer [MVP]]

You should be able to with Outlook automation. There are no COM object hooks
in Outlook Express. I'd ask this question in one of the Outlook newsgroups.
Someone there should be able to give you specific instructions on the
Outlook Object model. I have some simple Outlook automation code on my
website that will get you started, but it doesn't answer your specific
problem:

http://www.datastrat.com/Code/OutlookEmail.txt
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com