Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Copy and Paste into Outlook e-mail
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Copy and Paste into Outlook e-mail
It is not possible to copy / paste an entire sheet there.
The MailItem refers to complete mail item and not to the Body of the mail item. You can use Msg.Body = " ......................." But it has to be a string . you can not set Msg.Body to a Worksheet. Sharad "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! |
#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! |
Reply |
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 |