how can i copy excel content to the outlook indirectly through VBA

[chelsea]

Hi,

Every week i should click the hyperlink in the excel to send email, and i
need copy the excel content then paste in the outlook email . is there a
special excel vba to complete the whole process (copy & paste & send)?

Any help will be appreaciated.

Regards,
Chelsea

 

[Michael Bauer [MVP - Outlook]]

Am Mon, 23 Jun 2008 13:56:56 +0800 schrieb chelsea:


This sample demonstrates how to copy and paste from Outlook:
http://www.vboffice.net/sample.html?mnu=2&pub=6&lang=en&smp=41&cmd=showitem

--
Viele Gruesse
Michael Bauer - MVP Outlook

: VBOffice Reporter für Datenanalyse & Berichte
: Outlook-Kategorien? Category Manager ist die Lösung

 

[D]

I am having problems with this example. I keep getting an error with the
following line...

Set Doc = Application.ActiveInspector.WordEditor
It says "Object does not support this property or method"

Any ideas? (Office 2003)