One method that might help is documented he http://www.outlookcode.com/threads.a...essageid=20232

Also, the method shown here -- http://www.outlookcode.com/codedetail.aspx?id=1333 -- is for Word, but can also be used in Excel. You could, for example, copy and paste the desired range to a new worksheet then send it with this technique.

FYI, there is a newsgroup specifically for general Outlook programming issues "down the hall" at microsoft.public.outlook.program_vba or, via web interface, at http://www.microsoft.com/office/comm....program_v ba

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"thearch" wrote in message oups.com...
Hi all,

I am trying to automate the following procedure, but I have no clue as
how to do it.

Could you please advise?

I have a spreadsheet, and I want to copy the contents of a Range, WITH
formatting, and paste them into an HTML Email on Outlook.

How do I do it with VBA?

Thanks

Alessandro