Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

Josh Kahane

macrumors 6502
Original poster
Hi

As a company I want to send out emails to those on my mailing list. Currently I am having to do this manually and it taking far too much time.

I have two spreadsheet files. One with a list of emails. And one with a list of names.

Is it at all possible to automate this somehow so that all the email addresses are taken and carbon copied. Then also in each email the name is taken from the second file and put in like this:

Hi <name>

Do you know what I mean? So that it automatically put the name in with each email address. If I needed to change the file format or anything please say. This would be a great asset for me to have. Thanks.
 
Firstly, you should definitely merge the two files. Next, the feature you want is called "Mail Merge" and if you're using Excel/Entourage it's definitely there. I'm not sure about Numbers/Mail but it's a pretty standard productivity feature so I would assume something along its lines must exist. Good luck, lookup mail merge and you should be on the way!
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.