imbed query result into email..

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

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
 
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
 
Back
Top