Adding Outlook signature to email created by macro
 

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

Adding Outlook signature to email created by macro
 

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

Adding Outlook signature to email created by macro
 

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

Adding Outlook signature to email created by macro
 

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