Show a code snippet to illustrate how you're creating HTMLBody?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"john" wrote in message ...
I have written an Excel macro to create separate emails for each sheet in a
workbook, each email body contains the data as html (.HTMLBody).

If the Outlook "Tools - Options - Mail format" option "Use Microsoft Word to
edit e-mail Messages" is checked then I don't see the Excel data in the body
of the mail before I send it, but when I receive the mail the data is visible
(good). If I uncheck the "Use Word" option then I see the data before I send
the mails (even better).

The only problem is that my macro user wants to leave the Word option
checked but wants to see the data before sending the mails - anyone have any
ideas ? is this possible ?

Many thanks - John