Import contact info from Mac Address Book 4.0.6

[the magician]

At job, Mac OSX and Address Book 4.0.6 with contact info including in many cases emails. I'd like to get it of there, into Excel to manipulate, and ultimately into a FileWrecker Pro database. How to export 1087 entries from Address Book including only selective data fields is the question, and I know that's "slightly" OT, but I do want to import into Excel, so I hope that vindicates me! If not, and you can point me to a good MacForum, I'll settle.

Thanks.

el mago

"poof"

 

[the magician]

Norie - thanks for your time and thoughts, but if you read my first post, I kind-a mention that, although I do want to import into Excel at some point. With all the expertise on this board, I was hoping it might extend beyond Excel to MacAddressBook, and someone might point me in the right direction.

Thanks again. And..... still haven't seen your stuff. Sorry.

 

[mikerickson]

Did you see my post?

 

[the magician]

Mike - yes indeed I did. I ran it and it oddly left out 98% of the emails. I closed it all down and reran it and it worked. Gracias.

Would it be possible, if I were to provide you with a record that contained (to my best ability) all relevent fields including such as address and phone, that you can modify your code to go beyond name and email?

 

[mikerickson]

Sure.
If you Exit Sub just before the Redim resultRRay statement, it stops after importing the data and text to Columning. After that, its just re-arrange and parse.
Does the data match the example you posted?

 

[the magician]

The export function included only fields with data or that are administrative in some way. If there are three phones and two emails, it will include them on separate lines, otherwise they won't be there. I'll follow this with a post showing a more complete records with as much as I think I might care about, and if you can work with it, I'm much obliged.

You’ll see two emails, three phones, address, web url, and categories as follows:
EMAIL – WORK and EMAIL – HOME
TEL – WORK and TEL – CELL and TEL – HOME
ADR with ( from the right) zip, state, city, street semicolon delimited
URL with the colon “slashed” since AddressBook uses it as a delimiter
CATEGORIES a comma delimited string which can stay intact

Thanks Mike. Stay tuned.

 

[the magician]

BEGIN:VCARD
VERSION:3.0
N:Doe;John;;;
FN:John Doe
EMAIL;type=INTERNET;type=WORK;type=pref:email1@xxx.com
EMAIL;type=INTERNET;type=HOME:email2@yyy.com
TEL;type=WORK;type=pref: (800) 555-1212
TEL;type=CELL: (800) 555-2323
TEL;type=HOME: (800) 555-3434
item1.ADR;type=WORK;type=pref:;;123 My Street;My City Name;CT;12345-6789;
item1.X-ABADR:us
item2.URL;type=pref:http\://www.myhomepage.com
item2.X-ABLabel:_$!<HomePage>!$_
CATEGORIES:ArtParkCommittee-2008,evitelist14*,Volunteers-Maybe
X-ABUID:41E8A50B-1C46-44C4-89DC-1364D8DC9D28\:ABPerson
END:VCARD

 

[the magician]

Work done, on my way home, will log in this evening. thnx

 

[Norie]

Perhaps you should be looking on a Mac site because I don't see how Excel could affect this export.

Other than using code similar to what mike posted.

 

[Gerald Higgins]

Magician - the links in your signature appear to be broken

 

[the magician]

Gerald - thanks, all fixed. And I think your signature should include =DAY()+1=DOLLAR()-1. Not +1. ?