Excel to Outlook Macro (workbook attached)

Hey guys,

I am trying to create a macro that opens a new Outlook email filled with info from the excel sheet, but does not send.

The body of the email draft must appear as follows:

TO = B2
CC = B3
CC = B4
CC = B5
SUBJECT = B6
BODY = B7:B15

B7:B10 must be unformatted
B11:D13 must be formatted as is in excel
B14:B15 must be unformatted text

Attached is a worksheet that helps understand what I am describing. Any help regarding this is very much appreciated.

Mike

Have a look at Ron de Bruin's web site for email options.

http://www.rondebruin.nl/

Regards