Copy from Excel and Paste into Outlook

  • Thread starter Thread starter thearch
  • Start date Start date
T

thearch

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
 
One method that might help is documented here: http://www.outlookcode.com/threads.aspx?forumid=2&messageid=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/community/en-us/default.mspx?dg=microsoft.public.outlook.program_vba
 
Back
Top