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
Microsoft AccessVisual Basic Classic
Last Comment
John Tsioumpris
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Check this answer from EE