Exporting email addresses from address book into Numbers

Question

Exporting email addresses from address book into Numbers

Hi,

I am trying to export my email addresses to another person for a special email project. I exported them as vCards but she says she only sees one card (I know there are 171). So I tried to export or place them in Numbers but I can not get that to work either. Only the card title gets placed in my table even though I have added proper headings to the table. I ultimately want to get the email addressesin to Excel but I am having the same problem as with numbers. All ideas would be appreciated.
Thanks

Macbook Pro 17 inch, Mac OS X (10.6.2)

Posted on Mar 23, 2010 4:06 PM

Reply

Answer 1

Barney-15E

Level 10

112,914 points

Mar 23, 2010 5:33 PM in response to Western AZ Mac

Make a new Automator Workflow. Select Contacts from the Library pane and drag in a Get Selected address Book people. Drag in a Get Contact information action. Select the items you want and select export Format Spreadsheet (tabs). From the Text section, drag in a New Text Document. Go to address book and select the addresses you want to export and then run the workflow. Select all the text in the new text doc and paste it into excel.
I tried creating a new Excel Document, but it didn't work.

Now, if you open the combined vCard file you created with Text Edit, do you see all of the contacts in it? I had seen another thread that indicated a Windows user couldn't see more than one either, so I'm trying to hunt down the error.

Reply

Answer 2

Barney-15E

Level 10

112,914 points

Mar 23, 2010 6:01 PM in response to Barney-15E

Oops, sorry. For some reason I thought you said Excel. I'll give Numbers a try.

If you drag the vCards from Address Book into Numbers, it will import and format with First name, Last Name, Phone, and email

Message was edited by: Barney-15E

Help is a wonderful thing, in this case. I searched Numbers help for "Import vCards" and the first topic explained it. While it initially displays what I posted above, the rest of the columns are just hidden.

Message was edited by: Barney-15E

Reply

Answer 3

Mar 23, 2010 8:16 PM in response to Barney-15E

I read all of the help pages -- even downloaded the manual and I can not get vCards to set up in a Numbers table. All I get is the folder name in one of the fields when I drop the file. I have tried different sized vCards files and I tried dragging the file to various part of the table without luck. What else can I do? Thanks

Reply

Answer 4

Barney-15E

Level 10

112,914 points

Mar 23, 2010 8:43 PM in response to Western AZ Mac

What version of iWork do you have? Mine is '09.

Reply

Answer 5

Mar 23, 2010 9:13 PM in response to Barney-15E

Mine is current as well - Numbers 09 (Version 2.0.3 (332).

Reply

Answer 6

Barney-15E

Level 10

112,914 points

Mar 24, 2010 4:02 AM in response to Western AZ Mac

Ok. You are selecting a set of vCards, or a Group in Address Book, and dragging that into a numbers table? You must drag from within Address Book, not an exported vCard.

Reply

Answer 7

Mar 24, 2010 9:21 AM in response to Barney-15E

Barney,
Unbelievably simple when you do it the right way! I was using an exported file from my desktop!

Thank you!!

Reply

Answer 8

Barney-15E

Level 10

112,914 points

Mar 24, 2010 7:42 PM in response to Western AZ Mac

Western AZ Mac wrote:
Barney,
Unbelievably simple when you do it the right way! I was using an exported file from my desktop!

Thank you!!

I'm not sure why that doesn't work. I think it should. But since you can do it directly, why bother creating the exported file.

Reply