JENNIFER NEWTON
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
EE-Email-Question.jpg
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
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Check this answer from EE