| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Copy and Paste into Outlook e-mail
See
http://www.rondebruin.nl/sendmail.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Compuser" wrote in message om... This is what I'd like to do with VBA: COPY a range of cells in Excel and PASTE it into a new Outlook e-mail message. I know you can display an Excel worksheet or range in Outlook, but for my purposes, I'd like to COPY and PASTE. I found this on the web. Can someone please help adding to this? The mailitem object doesn't seem to support .paste. Sub Test Dim objApp As Outlook.Application Dim Msg As MailItem Set objApp = CreateObject("Outlook.Application") Set Msg = objApp.CreateItem(olMailItem) Sheets("Sheet1").Select Selection.Copy <<<<<What Do I put in here??? Msg.Recipients.Add ") Msg.Send End Sub I have both 2002 and 2003 versions of Excel & Outlook. Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy paste emails addresses from excel to outlook? | Excel Discussion (Misc queries) | |||
| copy & paste, a NEW CONCEPT (from Outlook to... Excel) | Excel Discussion (Misc queries) | |||
| copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
| Excel Copy/Paste into Outlook | Excel Discussion (Misc queries) | |||
| Copy and Paste from Excel into Outlook Email message | Excel Programming | |||
Threaded Mode
