Welcome to the MacNN Forums.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

You are here: MacNN Forums > Software - Troubleshooting and Discussion > Applications > import export

import export
Thread Tools
qnc
Mac Enthusiast
Join Date: May 2000
Location: London U.K.
Status: Offline
Reply With Quote
Jun 20, 2007, 01:18 PM
 
I have a list of names and emails in excell how do I get them to be a mailgroup in mail/address book?

Have tried dif to ldif... but it won't work ()

Can I make vcards from a list in xcel or use mailmerge or macros ?

Appart from copying and pasting the lot, any advise would be appreciated.!!
qnctv.com
Take a look...
     
Cold Warrior
Moderator
Join Date: Jan 2001
Location: Polwaristan
Status: Offline
Reply With Quote
Jun 20, 2007, 02:01 PM
 
I don't know about Mail, but Entourage can do it. Title your columns like First Name, Last Name, and Email Address. Export it as a tab-delimited file. Open Entourage, choose Import... from the file menu, and follow the steps from there. Basically the end result gives you new contacts in Entourage, which you can drag-drop onto your desktop, creating v-card files. Now open OS X's Address Book, create a new group (or select an existing one), and drag-drop all your v-cards into the group. This whole process should take about 4 minutes.
     
qnc  (op)
Mac Enthusiast
Join Date: May 2000
Location: London U.K.
Status: Offline
Reply With Quote
Jun 21, 2007, 12:05 PM
 
brilliant worked a treat..

also had to add familar category sp I could find them all upon import
qnctv.com
Take a look...
     
Cold Warrior
Moderator
Join Date: Jan 2001
Location: Polwaristan
Status: Offline
Reply With Quote
Jun 21, 2007, 12:33 PM
 
Good. Glad it worked for you.
     
   
 
Forum Links
Forum Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Top
Privacy Policy
All times are GMT -4. The time now is 06:23 AM.
All contents of these forums © 1995-2017 MacNN. All rights reserved.
Branding + Design: www.gesamtbild.com
vBulletin v.3.8.8 © 2000-2017, Jelsoft Enterprises Ltd.,