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.