Link to home
Start Free TrialLog in
Avatar of JENNIFER NEWTON
JENNIFER NEWTONFlag for United States of America

asked on

Inserting a datasheet query into the body of an email using VBA?

I'd like to have a function where a user presses a button and access creates an email where the body of an email is the results of a datasheet query.  Is such a thing possible?
EE-Email-Question.jpg
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

You can do 3 things
  • With VBA you can insert a table into the body of your email and "transfer" the query results to it
  • You can create an HTML table and populate it again with the results of your data....
  • Possible (not tested) copy paste the result of your datasheet to the email...it works for Excel as you can see in
  • this
  • post
Avatar of JENNIFER NEWTON

ASKER

•With VBA you can insert a table into the body of your email and "transfer" the query results to it

That's brilliant, John.  How would I do that?  I did a little google-fu and the only thing I can come up with is how to transfer a query or table as an attachment to an email.
ASKER CERTIFIED SOLUTION
Avatar of Norie
Norie

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Check this answer from EE