| Author | Thread |
|
|
10/16/2015 07:31:15 PM · #1 |
| 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? |
|
|
|
10/16/2015 07:34:21 PM · #2 |
|
|
|
10/16/2015 07:35:17 PM · #3 |
You actually get told when people leave?
Man, I want to work where you work. |
|
|
|
10/16/2015 07:35:44 PM · #4 |
| 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 ... |
|
|
|
10/16/2015 08:03:23 PM · #5 |
| Can you just bring up the last one, hit "reply all " & then edit as needed before you send? That's what I do. |
|
|
|
10/16/2015 08:22:45 PM · #6 |
| What did the last person responsible for this do? You know, before they saw their name on the list. |
|
|
|
10/16/2015 11:23:22 PM · #7 |
Originally posted by LN13:
You actually get told when people leave?
Man, I want to work where you work. |
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. |
|
|
|
10/17/2015 02:12:15 PM · #8 |
Originally posted by Cory:
Mailchimp |
Thx for the idea but not quite what I'm looking for, especially since it would go outside our org and they would not be cool with that |
|
|
|
10/17/2015 02:12:15 PM · #9 |
Originally posted by Pixelpig:
Can you just bring up the last one, hit "reply all " & then edit as needed before you send? That's what I do. |
thats what I'm trying to avoid, I would like to point it to my spreadsheet and have it grab the names if possible
Message edited by author 2015-10-17 14:13:32. |
|
|
|
10/17/2015 02:34:08 PM · #10 |
The General is correct about the term Mail-merge. I'd try that.
|
|
|
|
10/17/2015 03:49:25 PM · #11 |
| 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. |
|
|
|
10/17/2015 05:34:04 PM · #12 |
Assuming you are in a Microsoft environment, its not hard to use VBA to generate emails from excel.
Here's a link:
https://support.microsoft.com/en-us/kb/816644
|
|
|
|
10/18/2015 03:59:13 PM · #13 |
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.
Mike
|
|
Home -
Challenges -
Community -
League -
Photos -
Cameras -
Lenses -
Learn -
Prints! -
Help -
Terms of Use -
Privacy -
Top ^
DPChallenge, and website content and design, Copyright © 2001-2024 Challenging Technologies, LLC.
All digital photo copyrights belong to the photographers and may not be used without permission.
Current Server Time: 04/19/2024 05:41:37 AM EDT.
