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

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

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

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?...cmd=showite m

--
Viele Gruesse
Michael Bauer - MVP Outlook

: VBOffice Reporter für Datenanalyse & Berichte
: Outlook-Kategorien? Category Manager ist die Lösung
: http://www.vboffice.net/product.html?pub=6

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

how can i copy excel content to the outlook indirectly through
 

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)

"Michael Bauer [MVP - Outlook]" wrote:

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?...cmd=showite m

--
Viele Gruesse
Michael Bauer - MVP Outlook

: VBOffice Reporter für Datenanalyse & Berichte
: Outlook-Kategorien? Category Manager ist die Lösung
: http://www.vboffice.net/product.html?pub=6

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