View Single Post
  #1  
Old August 5th 08, 01:40 AM posted to microsoft.public.outlook.contacts
Stuart Dole
external usenet poster
 
Posts: 4
Default 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...)

Ads