So, at work I get the list when a group of people has been termed. I then have to send an email to the persons supervisor and find out if the termed person had any IS hardware and if the position is being back-filled or if we need to come recoup the hardware. I found tutorials for creating a template but what I really want to do is just be able to have a list of names and have the emails auto populate the names in the right spots and send them automatically. Anyone know how this might be done?
I vaguely know how to do something like that in Word or Quark, but not in any email program. You could look for a "feature" called "mail-merge" or something similar ...
Ha, yes, there are a whole host of people in my Division that has to know. People need to disable their network accounts, pick up old hardware etc. It's a large company so sometimes it disturbing because I can see people I know well but just haven't seen in a while.
Word does have a very good mail merge function. Google mail merge n Microsoft Word, and you'll find tutorials. Works great. Just what you're looking for.
We use a help desk ticket system that has a template created for hires and fires. When someone is termed, either the losing manager or HR fills out the ticket with all of the appropriate information (well, most of the time it's all filled out) of who, when, what to do with their email and any files, computer and/or laptop, phone, etc., and that comes into IT where the appropriate people act on the ticket. I don't care for the ticket system itself (Solarwinds) that we use but it does have decent template creation available.
You can create templates in Outlook, but you still have to enter the data somewhere. You can import and export between Excel and Outlook but I've not messed with the import of data.
