Macro to create a signature

**madbloke** · 10-21-2011, 05:38 AM

Hi,

At work, we've just been advised that all 3000 staff need to amend their email signatures to comply with corporate branding. Bearing in mind that several of these staff have genuinely called me to deal with broken PCs that weren't actually switched on!! I don't fancy trying to explain how to format signatures with custom colours etc.

Is there any way I could create a macro which would prompt them for the relevant info (name, location, extension etc), and then create a signature for them, all formatted correctly?

I have a reasonable knowledge of excel vba, but no experience in coding for Outlook - and the lack of a macro recorder makes it a bit impenetrable - any help would be appreciated.

**royUK** · 10-21-2011, 05:51 AM

You might be able to use this

http://www.rondebruin.nl/mail/folder3/signature.htm

**madbloke** · 10-21-2011, 06:19 AM

Ron, cheers for that, but that's for creating a mail with a signature inserted - I want to programatticaly CREATE a signature in outlook, that can be selected in the signature dropdown (this is what the staff are used to). Is this even possible?

**royUK** · 10-21-2011, 06:39 AM

I thought you could possibly adapt the code. I think the best thing is to create a Word template that your users can modify.

**madbloke** · 10-21-2011, 07:56 AM

Yup - unfortunately, I don't know enough about the Outlook model to adapt that into something that creates a sig. I think the template is probably the way to go.

Thanks!