#1
|
|||
|
|||
Paste special an Excel range into Outlook as an Excel Worksheet
I can (of course) select a range in Excel 2003 and paste special the range into an Outlook 2003 email as a "Microsoft Excel Worksheet".
I don't see any way to do this via VBA. VBA Help, the object model and Google haven't helped me find an answer. Is there a way to do this? If not, is there a way to force the in-construction email to be visible so I can manually do the Paste Special? Chuck |
#2
|
||||
|
||||
Basically, you'd need to use Word as your email editor, and use its Paste Special functions. See: http://www.outlook-answers.com/micro...o-outlook.aspx
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Pasting Excel object into Outlook
Paul -
I don't think your link is about the same thing. I want to paste an Excel range into Outlook as an OLE object, and that doesn't seem to be the point of your link. As for needing Word to be my email editor, on my machine it is not the editor yet I can manually paste special the Excel range into Outlook and it works perfectly. Chuck |
#4
|
||||
|
||||
Hi Chuck,
Indeed we are. Although you can use PasteSpecial through Outlook's GUI, Outlook has no vba equivalent of the PasteSpecial function. The only way around that is to automate Word as Outlook's email editor and use Word's vba PasteSpecial function. For a discussion, see: http://www.outlookbanter.com/outlook...ste-paste.html
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel - Color Worksheet Tabs | avie layne | Excel | 4 | 11-12-2012 04:45 PM |
How to Copy data from Outlook mail and Paste it in a Excel sheet? | padhu1989 | Outlook | 0 | 09-11-2012 04:07 AM |
Excel 2011 not performing paste special correctly | mzimmers | Excel | 1 | 01-04-2011 06:17 AM |
option Paste special...as 'Microsoft Excel Chart Object' NOT available | Intruder | PowerPoint | 0 | 12-24-2010 06:28 AM |
Using Paste/Special wih Excel data | chickasaw | PowerPoint | 0 | 02-05-2010 10:00 PM |