I have a macro in Excel 2003 that creates an email.

How do I add the default Outlook signature to this email through the macro?

Thanks

John

This should help

http://www.rondebruin.nl/mail/folder3/signature.htm
--
HTH,

Barb Reinhardt



"JohnG" wrote:

> I have a macro in Excel 2003 that creates an email.
>
> How do I add the default Outlook signature to this email through the macro?
>
> Thanks
>
> John

Thanks Barb, I'll take a look at that

John

"Barb Reinhardt" wrote:

> This should help
>
> http://www.rondebruin.nl/mail/folder3/signature.htm
> --
> HTH,
>
> Barb Reinhardt
>
>
>
> "JohnG" wrote:
>
> > I have a macro in Excel 2003 that creates an email.
> >
> > How do I add the default Outlook signature to this email through the macro?
> >
> > Thanks
> >
> > John

If you are automating Outlook using its object model, just call the
MailItem.Display method. That will cause Outlook to add the signature
to the email.

--JP

On Mar 31, 7:27*am, JohnG <Jo...@discussions.microsoft.com> wrote:
> I have a macro in Excel 2003 that creates an email.
>
> How do I add the default Outlook signature to this email through the macro?
>
> Thanks
>
> John