Avatar of Lawrence Salvucci
Lawrence Salvucci
Flag for United States of America asked on

Outlook Signature using VBA

Not sure if this is possible but I thought I would ask. We have different email signatures that we use throughout our company. We want to change these signatures monthly for all users. Is there a way to have it use a specific email signature for a given month? For example if we had SignatureA, SignatureB, and SignatureC and wanted to use SignatureA for January, February, and March. And then SignatureB for April, May, and June. And then SignatureC for the balance of the year. Could this be done in VBA code so the users don't have to remember to switch the signature? Or maybe have a list of the signature names in an Excel file with date ranges and have Outlook look at this file before it sends an email to see which signature to use based on the current date. But something like this would need to be set up on all my users Outlook program.

Avatar of undefined
Last Comment
David Lee

8/22/2022 - Mon
Randy Poole

The only way I know you could accomplish this by doing this in Outlook is to capture the thisOutlookSession objects event:
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean)

Open in new window

Make sure there are no default signatures enabled for the account, then append the HTMLBody or Body of the item passed to the event based upon if this is an HTML email or plain text.
Lawrence Salvucci

I'm not very tech savvy with VBA so I really wouldn't know where to start with this. Would it make sense to store these signatures in a Word Doc already formatted and then have all the users pull the signature from this file? This way we could change the Word Doc based on what signature we wanted to use.
David Lee

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Lawrence Salvucci

Yes that makes sense. I think that's a good solution. I'll set that up and see how it works. Thank you for your help!
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
David Lee

You're welcome.