Use VBA for company e-mail signature

[dotobi]

Hi

After searching though the Exchange forum, I feel that this could be better achieved with VBA... let's see...

I'd like to create a company wide e-mail Signature that is something like this:

Regards,

{user.firstname} {user.surname}

Email: {user.email}
Phone: {user.phone}

This isn't covered with M$ Exchange. I've found there are programs out there that do this, but most add the signature after the e-mail is sent (like a disclaimer) so the user has no way of editing or deleting it.

So, I was wondering if there is a way to use VBA to either communicate with Active Directory (preferred) or some kind of central database of Users' Details and create and add the signature on every new e-mail.

This thread thread707-793417 seems to deal with this issue, but I don't understand the info in the Thread.

I intend to use the ItemSend event to adjust the HTML of the message body on the fly... [and] ... replace variable placeholders embedded in the signature with their actual values at time of sending

???????????????????

I'm not experienced with VBA, so even just pointers in the right direction would be a great help.

Thanks!

keV

SYSTEM INFO: Windows Small Business Server 2003 SP1 (inc. SBS version of Exchange 2003), Windows XP Pro SP2, Office Basic 2003 SP2 (Outlook, Word & Excel).