S
Stuart Dole
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...)
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...)