Create a mass email from a Numbers spreadsheet

Joined
Oct 13, 2006
Messages
724
Reaction score
60
Points
28
Location
Blacksburg, VA
Your Mac's Specs
13'' Macbook w/ 2Ghz Core Duo, 2GB DDR2, 250GB HD, 10.5.4. iPod Touch.
I have a spreadsheet in Numbers that contains contact information for an organization that I am in. One of the fields in said spreadsheet is "email addresses".

How can I tell Apple Mail to address an email with all addresses in the entire spreadsheet? Simply selecting the entire column and dragging it to mail does not seem to work.
 
Joined
Oct 22, 2007
Messages
8,967
Reaction score
287
Points
83
Location
London
Your Mac's Specs
Mac Mini Core i7 2012 | White 2009 MacBook 2 Ghz | 733 Mhz G4 Quicksilver
I think you could par the list down to firstname, lastname and email address and save the result as a tab delimited text file.

You could then import that in to address book

One in address book you could create a group of all those new addresses

I would think mail could then use this group, just make sure you add the group to the BCC field to avoid bad netiquette
 
OP
walmartconnect
Joined
Oct 13, 2006
Messages
724
Reaction score
60
Points
28
Location
Blacksburg, VA
Your Mac's Specs
13'' Macbook w/ 2Ghz Core Duo, 2GB DDR2, 250GB HD, 10.5.4. iPod Touch.
Aye, I just wasn't sure if there was an easier "it just works!" built in kind of way. thanks.
 
Joined
Oct 22, 2007
Messages
8,967
Reaction score
287
Points
83
Location
London
Your Mac's Specs
Mac Mini Core i7 2012 | White 2009 MacBook 2 Ghz | 733 Mhz G4 Quicksilver
I dunno, you mac users just expect everything to be easy ;)

when's your tour over BTW
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top