COPY/PASTE to body of email the format of Excell cell

[LetMeDoIt]

Greetings,

Hope you can help with this. I am currently sending emails from Excel
using VBA code. The content of the email copies from certain cells in
Excel then pastes them to the email body (in this case using outlook.

Is there a way I can copy/paste from Excel a range of cells, this
includes the format of the cells (background color, etc) ?

Many thanks,
regards, CG

 

[Ron de Bruin]

Hi LetMeDoIt

See the Outlook body section on this page
http://www.rondebruin.nl/sendmail.htm

 

[LetMeDoIt]

Thank you Ron. Your link is VERY usefull. I should have look there
first prior to posting. Many thanks,
regards CG