J
Jamie141
How can I get my Outlook signature on the bottom of an email sent out of Excel?
B
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)
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)
Excel?Jamie141 said:
J
Jamie141
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
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
R
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
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