Formatting an email (1 Viewer)

[G81]

Hi guys,

Ive been using the outlook.application method to email results from various queries like this:

.Body = "1)" & Chr(13) & Chr(13) _
            & s1 & Chr(13) _
            & "2)" & Chr(13) & Chr(13) _
            & s2 & Chr(13) & Chr(13) _
            & "3)" & Chr(13) & Chr(13) _
            & s3 & Chr(13) & Chr(13) _
            & "4)" & Chr(13) & Chr(13) _
            & s4 & Chr(13) _
            & "5)" & Chr(13) & Chr(13) _
            & s5 & Chr(13) & Chr(13) _
            & "6)" & Chr(13) & Chr(13) _
            & s6

It works perfectly but I would rather the results be shown in tables, like when you copy and paste selected cells from a select query into an email.

Can someone point me in the right direction for formatting tips when emailing in vba?

 

[boblarson]

Look into using HTML to create a table and making sure the mail type is set to HTML.

 

[G81]

cheers Bob. I actually found a great bit of code by one of our own members here:

http://www.access-programmers.co.uk...p?t=162910&highlight=html+outlook.application