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

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...41&cmd=showitem

--
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

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...41&cmd=showitem
>
> --
> 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
>