[Access] How to create tables in emails using VBA in access?

[spidermman]

Hi

I have a form in access which contains a 6 x 4 table and some instructions (text) on loading of products.

I would like to create an email based on the template of this form.

How do you create tables in emails using VBA in access?



DoCmd.SendObject


thanks

[OBP]

I know it doesn't answer your question directly, but how about sending the Form as an attachment?
You can aslo convert the Form to a Repprt and send that instaed.

[FrymanTCU]

I've used HTML to build a string that contains Access data that looks pretty clean in email. I find all my HTML answers with Google...

Simple Example:
strTable = strTable & "HTML" & Feild
Loop