How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Mike Your Own Question

Mike
Mike, Mac Medic
Category: Mac
Satisfied Customers: 6701
Experience:  Over 20 years IT experience with Apple computers in publishing, marketing and design.
25267123
Type Your Mac Question Here...
Mike is online now
A new question is answered every 9 seconds

Which programs does mac support to export & import my address

Resolved Question:

Which programs does mac support to export & import my address book?

I have mistakenly entered a lengthy address book on my email address book
with earthlink.net. This cannot be printed out. I need to transfer this
information to a database in microsoft so that I can edit it and print
out a hard copy.
Submitted: 4 years ago.
Category: Mac
Expert:  Mike replied 4 years ago.
Chat Conversation Started
Mike the MacMedic :

You need to export your contacts from Earthlink to a .cvs file.

Customer:

will you give me explicit (step by step) instructions on how to export to .cvs file.

Customer:

continuing with reply: is cvs file and addresss?

Mike the MacMedic :

Export Address Book: Web Mail can export your list of contacts to a "comma separated value" (CSV) file that can be read by many other applications, such as Microsoft Excel. To export your address book, click the Export Address Book link, then save the file to your desktop.

Mike the MacMedic :

I don‘t have an Earthlink account so I can’t show you exactly where that is. Do you see it?

Customer:

Under services in address book I find in BOLD, meaning available:

Customer:

chinese text converter, disk utility, finder, font book, grab, Import Image, mail, skype, speech, text edit

Customer:

I tried Import impage: it said "No Image Capture Device"

Customer:

in "grey text" ie not available probably:

Customer:

open URL, Search with Google, Send file to Blue Tooth Device

Customer:

I'm do not think I have Blue Tooth. What do you suggest?

Mike the MacMedic :

Where are your contacts stored on Earthlink’s webmail page or in Address Book on your Mac?

Customer:

contacts are stored on Earthlink's webmail page (not sure what you mean -- the address book that is pictured by the "a" icon

Customer:

on the dock. To get to the address book I click on that icon. Email addresses are entered into this place by clicking on the

Customer:

senders email, a window opens with options one of which is "add to address book"

Customer:

I have added information, addresses, phone numbers, notes to these entries in the address book

Customer:

all that information is what I want to save and transfer to Microsoft word (or Excel).

Mike the MacMedic :

So all your contacts are listed properly in Address Book?

Customer:

Not quite yet. I just discovered that I must remove the commas between first and last names.

Customer:

Should this be done before transfer, or can it be done later in data base. So hope transfer is possible!

Mike the MacMedic :

What Microsoft program exactly do you want to export to?

Mike the MacMedic :

If all you want to do is print them you can do that from Address book.

Customer:

I want to export to Microsoft Word.

Customer:

No, I cannot print from the earthlink address book, that is why I've contacted you

Customer:

From Earthlink Address Book to Microsoft Word to enter information into a data base.

Mike the MacMedic :

We are not understanding each other. I asked if you had your contacts in Address Book on the Mac. Go to Applications/Address Book. Are your contacts there?

Customer:

Yes. I have gone to Applications, clicked Address Book, and brought up the double columns.

Customer:

This is the address book.

Mike the MacMedic :

OK so it is not the Address Book on Earthlink‘s site? All your contacts are there in the Apple Address Book application?

Customer:

I guess they must be. I do not understand. What next?

Mike the MacMedic :

If you want to print it select any contact and hit Command/A to select all. Then go to File/Print and choose what fields you want to print. Now you want to export this and bring it into Word, correct?

Customer:

yes

Customer:

When I go to file/print the print option is grey, does not function. That is why I've contacted you.

Customer:

There are so fields in print/file.

Mike the MacMedic :

Did you select all the contacts?

Customer:

well, I just hit print. It says " not matching cards ".

Customer:

yes, I selected all the contacts. I'll try once again. hold on. I've repeated

Customer:

this and get same response. I have just noticed that on the File

Mike the MacMedic :

OK select all contacts again and go to File/Export/Export Group vCard and save. Then go here to convert to .csv, then you can open with Excel or Word.

Customer:

column there is an Import and an Export possible.

Customer:

going ahead with above

Customer:

when I clicked vCard, what appeared on left were my documents, not my address book.

Customer:

I went ahead a hit save. I will now repeat to see if there is a different result

Mike the MacMedic :

What documents? There are no “documents” in Address Book?

Customer:

This time, instead of vCard I clicked address archive which appeared below vCard

Customer:

I have saved this.

Mike the MacMedic :

You can’t convert that it has to be vCard.

Customer:

Should I go ahead to the here to convert to .csv? mac asks me if I want to leave the page we are on.

Customer:

I hesitate and am asking you.

Mike the MacMedic :

Just book mark the page.

Customer:

well, just read you saying it has to be a vCard. I'm stuck

Mike the MacMedic :

I don‘t understand, just export to vCard and ignore what you see on the left

Customer:

ok

Customer:

now i've saved the vCard box. Next step please.

Mike the MacMedic :

Go to that webpage and convert.

Customer:

sorry mike, I do not under stand what "that webpage" is nor what is "convert"

Mike the MacMedic :

From earlier: OK select all contacts again and go to File/Export/Export Group vCard and save. Then go here to convert to .csv, then you can open with Excel or Word. Click on Here.

Customer:

Clicked on Here. The file being converted was my documenst. I selected Address book w/date on it and then convert.

Customer:

Message appeared: "could not parse vCard. Either it is empty or of a format not supported".

Customer:

trying again

Mike the MacMedic :

Choose csv from format options.

Customer:

I've chosen csv. I've then entered Address Book 2010-8-01.abbu.vcf as instructed. This is a stone wall as computer

Customer:

will not save it with the vcf, only the abbu. When I am working with the option of cvs, there is no way to

Customer:

get out of the above except to cancel; otherwise the screen will not change.

Customer:

No way forward?

Customer:

Perhaps I should reformat the address book . . . since the one time I seemed to get through the "could nto

Customer:

parse vCard message appeared.

Mike the MacMedic :

Go here with any web browser and sign in. Click on upload and choose your Exported vCard file? Let me know when completed.

http://momandpop.ws:8000

username: justanswer
password: macmedic

Mike the MacMedic :

Are you sure you have all the contacts selected like this?

Full Size Image

Customer:

yes

Mike the MacMedic :

OK let me know when uploaded.

Customer:

well, I took the contact selected as directed above (and thought I'd done that several times before).

Customer:

I'll skip the pounding about. Now, as I've converted, the Microsoft Word says I have three downloads of

Customer:

the address book as sent with the . . . vcf added . . .

Customer:

I do not know how to pull up the downloads. I'm a truly dull case.

Mike the MacMedic :

When you are in to the site choose Upload.

Full Size Image

Customer:

I am in word. Services does not have an upload. Perhaps I do not understand the word site.

Mike the MacMedic :

We are not communicating I will opt out and let other experts help you.

Customer:

Thank you Mike. I must leave the computer. I will pay, but so not have problem solved.

Mike the MacMedic :

Thanks you good luck

Customer:

I now need to know how to import into Microsoft word.

Customer:

I also need to know whether you charge more than the fee I have

Customer:

promised. This is the first time I've used a service.

Mike the MacMedic :

So you have the exported vCard file?

Customer:

When I go to Microsoft Word and click Documents, I now have a site named vCards.

Customer:

Clicking on this, nothing happens. On 8/1 I got lost in a process of trying to

Customer:

allow import into Word. I had finally realized I could click into your Full Size Image

Customer:

but I could not find this in my Word.

Customer:

I could find no way to bring up Web File Manager.

Mike the MacMedic :

Use this to convert to whatever format you want: http://labs.brotherli.ch/vcfconvert/

Customer:

I have recorded the http above and will try that out.

Mike, Mac Medic
Category: Mac
Satisfied Customers: 6701
Experience: Over 20 years IT experience with Apple computers in publishing, marketing and design.
Mike and 2 other Mac Specialists are ready to help you

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill Bill M. Schenectady, New York
< Last | Next >
  • Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill Bill M. Schenectady, New York
  • The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you! Frank Canada
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
 
 
 

Meet The Experts:

 
 
 
  • Mike

    Mac Medic

    Satisfied Customers:

    6256
    Over 20 years IT experience with Apple computers in publishing, marketing and design.
< Last | Next >
  • http://ww2.justanswer.com/uploads/macthelife/2009-10-20_1899_mikesebaharsquare64.jpg Mike's Avatar

    Mike

    Mac Medic

    Satisfied Customers:

    6256
    Over 20 years IT experience with Apple computers in publishing, marketing and design.
  • http://ww2.justanswer.com/uploads/AS/ashiknasameen/2012-5-15_141836_final2.64x64.jpg Ashik's Avatar

    Ashik

    Mac Helper

    Satisfied Customers:

    5282
    7+ Years of Experience in troubleshooting Macs, iPhone, iPad, iPod etc
  • http://ww2.justanswer.com/uploads/DP/dpean/2012-6-6_172828_avatorme1.64x64.JPG Daniel's Avatar

    Daniel

    Mac Genius

    Satisfied Customers:

    4670
    Apple certified on desktop and portable, help desk qualified. Have owned and used Macs since 1989.
  • http://ww2.justanswer.com/uploads/VI/vinodvmenon2005/1.64x64.jpg Vinod Menon's Avatar

    Vinod Menon

    Support Specialist

    Satisfied Customers:

    2068
    worked as a Tech support Associate for Apple products
  • http://ww2.justanswer.com/uploads/BE/beboo/2011-1-14_201648_n5063313142021801763.64x64.jpg Brandon M.'s Avatar

    Brandon M.

    Mac Support Specialist

    Satisfied Customers:

    1501
    10+ Years Mac Support as contractor and currently an IT Manager for law firm
  • http://ww2.justanswer.com/uploads/MA/MacDruid/IMG_0232.64x64.JPG John T. F.'s Avatar

    John T. F.

    Mac Druid

    Satisfied Customers:

    1408
    20+ years in the computer/Mac industry
  • http://ww2.justanswer.com/uploads/MA/MacHelpdesk/1d2d506.64x64.jpg David's Avatar

    David

    Mac Support Specialist

    Satisfied Customers:

    1236
    BSc, H.Dip, Apple Certified