If you wish to send an e-mail in a tubular format then you will need to use
outlook automation in HTML format and use HTML coding to create your format.
For basic information on automating outlook se
http://msdn.microsoft.com/en-us/lib...odc_ac_olauto_sendanoutlookmessageusingaccess
However, you will need to switch the .body to .HTMLbody and then build your
content/HTMLbody content using standard HTML tags.
You need to code your message as if you were creating a HTML document, all
the standard tag apply (<i></i>, <b></b>, <br/>, <p>, <h1>,..., <h6>, <a
href>..., <img src>...., ...). Make sure you use opening and closing <HTML>
and <BODY> tags.
An alternative would be to create a report an simply include the report as
an attachment in a basic e-mail, thus avoiding the need to build custom HTML
code.
--
Hope this helps,
Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples:
http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.