Hi Charles
Formatted text (HTML)
If you want to create emails that are formatted you can use HTMLBody (Office 2000 and up) instead of Body.
You can find a lot of WebPages on the internet with HTML tags examples.
strbody = "<H3><B>Dear Customer</B></H3>" & _
"Please visit this website to download the new version.<br>" & _
"Let me know if you have problems.<br>" & _
"<A HREF=""
http://www.rondebruin.nl/"">Ron's Excel Page</A>" & _
"<br><br><B>Thank you</B>"
Use .HTMLBody = strbody then instead of .Body = strbody
If you want to send a range or worksheet as HTML see this two examples.
Range/Selectionhttp://
www.rondebruin.nl/mail/folder3/mail4.htm
Whole worksheethttp://
www.rondebruin.nl/mail/folder3/mail2.htm