VBCrlf & Creating a Table

[nathan_savidge]

Hi,

I am creating an automatic email to a variety of people with the results
from a record set.

I am currently coding as rst.fields("Date").value & vbTab &
rst.fields("Note").value & vbcrlf

This works fine, but i would like to add the results to a table for
neatness, similar to how i would in HTML. I don't know how to create a table
(not a database table) in access coding.

Can anyone help.

 

[Alex Dybenko]

hi,
you can try to create outlook message with HTML, something like this:
http://www.mvps.org/access/modules/mdl0019.htm
or
http://support.microsoft.com/kb/153311/EN-US/

and set html to HTMLBody property

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com