I'd like to import data from Mac's Address Book into Excel in discrete contact information and be able to import only the specific fields of interest. Then I'd like to export it to Word doing a mail merge in order to print out a booklet and then print out mailing labels for another project. I can't seem to find an export format in the Address Book that will allow this. vcards seem so restrictive and text probably won't contain enough formatting information. I don't want to use Entourage or other contact database as I've spent too much time tweaking this one and using .Mac to synchronize the data.
On 5/20/08 6:34 PM, in article ee9a560.2@webcrossing.caR9absDaxw, "Norman
Soskel" <artist@memphisthings.com> wrote:
> I'd like to import data from Mac's Address Book into Excel in discrete contact
> information and be able to import only the specific fields of interest. Then
[quoted text clipped - 4 lines]
> don't want to use Entourage or other contact database as I've spent too much
> time tweaking this one and using .Mac to synchronize the data.
Well, I do not use Apple's address book, but...
You should be able to export the data as a tab delimited text file. This
usually will be all the data. When read by Excel, you can simply delete the
columns you do not want or need, save it and use the result as input for
your merge.

Signature
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom