Exports Outlook Contacts

K

Kelly

I have an outlook 2003 contact folder that I would like to export to an excel
spreadsheet. My problem is that I want to export the address based on the
box that is checked denoting "This is the mail to address". I cannot find a
field anywhere that denotes which address (business, home, or other) is the
mailing address. Does anyone know how to do this? I don't necessarily have
to export directly to excel, but I do need to eventually end up with the
addresses in an excel spreadsheet. Any help would be greatly appreciated.
 
R

Russ Valentine [MVP-Outlook]

"Mailing Address" is a derived field that Outlook creates. It is never a
good idea to try to export a derived field, nor is it even possible in most
cases. You need to export the actual address element fields.
 
K

Karl Timmermans

The Outlook import/export wizard does not provide the option to either
export/import this info. As Russ states - mailing address is "derived" -
from one of the 3 primary addresses. Two 3rd party solutions that can solve
your "mailing address" requirement are:

#1 - CodeTwo - Outlook Export (free) - not related to us - provided as info
only
http://www.codetwo.com/pages/freeware/outlook_export.php

#2 - ContactGenie Exporter (not free) - has more/different features/options
Features: http://www.contactgenie.com/cgxfeatures.htm
D/L: http://www.contactgenie.com/cg20dlorder.htm

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com






Russ Valentine said:
"Mailing Address" is a derived field that Outlook creates. It is never a
good idea to try to export a derived field, nor is it even possible in
most cases. You need to export the actual address element fields.
--
Russ Valentine
[MVP-Outlook]
Kelly said:
I have an outlook 2003 contact folder that I would like to export to an
excel
spreadsheet. My problem is that I want to export the address based on
the
box that is checked denoting "This is the mail to address". I cannot
find a
field anywhere that denotes which address (business, home, or other) is
the
mailing address. Does anyone know how to do this? I don't necessarily
have
to export directly to excel, but I do need to eventually end up with the
addresses in an excel spreadsheet. Any help would be greatly
appreciated.
 

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