In MSaccess I create an email using:
DoCmd.SendObject acReport, stDocName, acFormatHTML, Cust_email, , , MyTitle , MyWaffle
Where Mywaffle is a long text string that forms the message of the email.
This is plain text using vbcrlf and vbtab to lay out the message.
I now want to create the message in html to get it to look better; how do I do that?
How do you imbed the html document into the email message?
I have created a template file, but not sure how to get the data (using visual basic) to the variable
ie how do a populate <!--AcessTemplate_Body--> with data?
Or do you just put the html tags in the string (mywaffle), if so what setting in outlook do you need to change to get it to work?