How can I easily export mailing addresses?

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...)
 
D

Diane Poremsky [MVP]

Don't use the mailing address fields, use the city state and zip fields (not
business address, home address or other address fields) - as you can see,
the mailing address is the same as the non-identified addresses - this is a
business address and was repeated in the business address fields. If the
home address was the mailing address it would also use the fields below.

Mailing AddressP.O.
Box 27412
Richmond, VA 23269

PO Box Street Address City State Country/Region ZIP/Postal Code
P.O. Box 27412 Richmond VA United States of America 23269Use the field chooser to add the address fields. Once you make the view with
the fields you need you can either paste it into excel or export to csv or
excel format - I think copy and paste is easier.

See http://www.slipstick.com/Tutorials/copyto/excel.htm

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.
 
S

Stuart Dole

Thanks Diane! Looks like it will be useful.

Say, here's a related question: are "Categories" the only way to really deal
with different kinds of contacts? It looks like "Groups" are limited to only
email lists - is that true? For example, we offer workshops and talks in our
local area, and would like to keep track of who has taken which ones, which
gets to a lot of categories pretty soon. (Which leaves out synching to a
Palm, which is limited to 15 categories by design!) How would you organize
this? (This was something that's easy on ACT!)

For instance, we'd like to send postcards to everyone that has not attended
any of the "Fall Pumpkin Carving Workshops" but has been to a "Planting
Summer Squash" talk...

I'll explore your website some and see if there are ideas there.

Many thanks and happy trails,
Stuart



Diane Poremsky said:
Don't use the mailing address fields, use the city state and zip fields (not
business address, home address or other address fields) - as you can see,
................
 
D

Diane Poremsky [MVP]

Categories would be the best option if you insist on using Outlook for it.
Personally, I would use Access if the list of contacts is very large - it’s
a true relational database and can handle that type of data better.

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.
 
S

Stuart Dole

Thanks again Diane...

Hmmm - I know Access is a pretty good relational database (I used one of the
earliest versions for a project once), but is there an easy way to do this,
where Outlook and Access stay in synch? I'll look into it. I'd rather not
take a week or two to DIY - I guess I'm lazy in my old age (I used to be a
software engineer), and "out of the box" solutions are attractive - I'd
rather spend my time doing what I'm doing, but I can dust off my old software
chops if needed...

Happy trails & thanks again,
Stuart

Diane Poremsky said:
Categories would be the best option if you insist on using Outlook for it.
Personally, I would use Access if the list of contacts is very large - it’s
a true relational database and can handle that type of data better.

--
...............
 
D

Diane Poremsky [MVP]

you can link outlook and access - its one of the external data options in
Access.

--
Diane Poremsky [MVP - Outlook]
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
(e-mail address removed)

EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)




You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top