How can I easily export mailing addresses?
Hi:
I'd like to be able to export the "mailing address" of a selected group of
contacts - either by category or group. Note that the "mailing address" is
either the business address or the home address, depending on the check-mark
in the individual contact.
I'd like it to end up in Excel (imagine that!) with columns for "Full Name"
and "Mailing Address" - like I can display it in the "view by category" list.
I tried to simply copy and paste (seems like it *should* work) into Excel,
but alas it makes TWO (2) rows for each contact, somehow split in the middle
of the "Mailing Address" field. (Why is it being so difficult?)
How about a simple "Export as CSV" or some such?
The eventual target of all this is an on-line postcard printing company that
wants an Excel workbook of the addresses in a simple format (First Name, Last
Name, Address, City, State, ZIP).
I need to be able to do this by Groups too!
Any suggestions welcome.
(This used to be easy with ACT!, but now ACT! is broken...)
|