Excel/Word VB Coding question
I'm looking to take a list of staff and create their E-mail signatures (becuase they can't be trusted to do it themselves) and I'm looking for some ideas.
The signature files are saved as 2 text files where just the variables such as phone number, name and job title would change.
now I could create all this as a mail merge but I would need to save each file individually (which would be the issue). Alternatively if could output direct from excel into the text file this would be fine.
But I'm at a bit of a loss about the best way to create the output. Is there a way to use the VB script to acomplish this task.
If it makes more sense I would start with a list
Person1 Job1 Phone1
Person2 Job2 Phone2
And export the text
To a file <filename>.txt