![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
![]()
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. |
#2
|
|||
|
|||
![]()
"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" wrote in message ... 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. |
#3
|
|||
|
|||
![]()
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 a #1 - CodeTwo - Outlook Export (free) - not related to us - provided as info only http://www.codetwo.com/pages/freewar...ook_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 [MVP-Outlook]" wrote in message ... "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" wrote in message ... 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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Quick find in contacts cannot locate some contacts in large address book (over 1300 contacts) | [email protected] | Outlook - Using Contacts | 1 | September 27th 07 06:42 PM |
How to share outlook 2003 customize contacts or contacts subfolder without do it on public folder? | Sue Mosher [MVP-Outlook] | Outlook - Using Contacts | 4 | June 28th 07 11:45 PM |
changing contacts frm global address list to contacts in outlook 2003 | Steven S | Outlook - General Queries | 1 | December 7th 06 03:51 AM |
exporting outlook contacts, not all data exports? | kbeauvais | Outlook - Using Contacts | 0 | May 16th 06 05:35 PM |
outlook 2003 no longer exports claanders to Timex Data watch | Larry | Outlook - Using Contacts | 2 | February 17th 06 05:09 PM |