how do I paste Excel clipboard cells to Outlook Word Editor and send it out using VBA?

[LunaMoon]

Hi all,

I want to do the following using VBA, and ultimately using COM/
ActiveX. But since they are similar, lets start with VBA.

Lets say I have copied some cells (with formatting) to clipboard from
Excel.

How do I paste this clipboard to Outlook Word Editor 2003 as an image
and send it out using VBA/COM/ActiveX?

Thanks a lot!

[Ken Slovak]

Outlook doesn't have any methods for using the clipboard, and VBA doesn't
provide any clipboard methods as VB6 would. You will need to review the
methods for using the clipboard using the Win32 API calls for the clipboard.
There is code for that in VB6 that you can modify to use in VBA at Randy
Birch's Web site and code samples at www.mvps.org. You can also search on
the Web for VB6 or VBA sample code for that.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm

Post by LunaMoon
Hi all,
I want to do the following using VBA, and ultimately using COM/
ActiveX. But since they are similar, lets start with VBA.
Lets say I have copied some cells (with formatting) to clipboard from
Excel.
How do I paste this clipboard to Outlook Word Editor 2003 as an image
and send it out using VBA/COM/ActiveX?
Thanks a lot!