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

Hi LetMeDoIt

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"LetMeDoIt" <(E-Mail Removed)> wrote in message news:bb61ee0f-3d2b-4bea-a7ec-(E-Mail Removed)...
> 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

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