Signature on an Excel email

[Guest]

How can I get my Outlook signature on the bottom of an email sent out of Excel?

 

[Bob Phillips]

See

Insert Outlook Signature in mail
http://www.rondebruin.nl/mail/folder3/signature.htm

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

How can I get my Outlook signature on the bottom of an email sent out of

Excel?

 

[Guest]

Hi Bob, thanks, I wish I were more techy, I really don't understand what to
do after I've placed the checkmark next to Microsoft Outlook in the VBA
editor. What do I do with "Sub Mail_Outlook_With_Signature_Plain ()". If
you don't have time to explain this, don't worry about it

 

[Ron de Bruin]

Hi Jamie

You must copy the macro and the function in a normal module

Alt-F11
Insert>Module from the menubar
paste the sub and function there
Alt-Q to go back to Excel

Change Mysig.txt to the name of your sig in the code
and change .Send to .Display for testing

If you do Alt-F8 you get a list of your macro's
Select "Mail_Outlook_With_Signature_Plain" and press Run