|
| 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
August 1st 07, 06:34 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
How can I select mailing address when exporting outlook to excel?
I know this is an old post but I'm having the same issue today with Outlook
2003. I checked out the utility posted by someone, but it seems that the utility requires a Microsoft Exchange Server (which I don't have) and may be geared for large corporate environments---I'm just a single user. Are there any known utilites for exporting the MAILING addresses from Outlook to Excel? The Mapping feature in Outlook shows Home address, business address and Other address, but does not allow one to chose the one that is the actual Mailing address for contacts that have multiple addresses. Please help! "desperate david" wrote: I have approx 1800 names & addresses in my Contacts. Most of these have more than one address. When displayed I have an option of ticking the Mailing Address. This is fine when doing a mail merge for a mailing. I am about to use a new company for mailing. They need my Mailing List in an Excel format. I know how to export to an Excel doc' but is does not let me chose the mailing address. this means that I will have to sift through 1800 address deleting as necessary. Does any kind soul know of a way round this? pretty please. 
|
|
#2
August 2nd 07, 01:46 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
How can I select mailing address when exporting outlook to excel?
Can you describe the OUTCOME you want rather than the method that you think
won't work. Then we can explain ways to go about achieveing what you want. Thanks Judy Gleeson MVP Outlook Outlook trainer and author of Productiv_IT with Outlook read my articles he www.judygleeson.com Canberra, Australia how to post questions: http://support.microsoft.com/?id=555375 "needs help badly!" wrote in message ... I know this is an old post but I'm having the same issue today with Outlook 2003. I checked out the utility posted by someone, but it seems that the utility requires a Microsoft Exchange Server (which I don't have) and may be geared for large corporate environments---I'm just a single user. Are there any known utilites for exporting the MAILING addresses from Outlook to Excel? The Mapping feature in Outlook shows Home address, business address and Other address, but does not allow one to chose the one that is the actual Mailing address for contacts that have multiple addresses. Please help! "desperate david" wrote: I have approx 1800 names & addresses in my Contacts. Most of these have more than one address. When displayed I have an option of ticking the Mailing Address. This is fine when doing a mail merge for a mailing. I am about to use a new company for mailing. They need my Mailing List in an Excel format. I know how to export to an Excel doc' but is does not let me chose the mailing address. this means that I will have to sift through 1800 address deleting as necessary. Does any kind soul know of a way round this? pretty please.
|
|
#3
August 2nd 07, 11:50 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
How can I select mailing address when exporting outlook to exc
Hi Judy---I think the original poster stated the desired outcome clearly, and
I have the same desired outcome. I.e. we want to export MAILING addresses from Outlook Contacts to Excel. I know how to export addresses, BUT most of my contacts have more than one address and I need to export the one that I have checked off indicating that it's the mailing address. Sometimes it's a home address, sometimes it's a business address and sometimes it something else (Other). But it is different for every contact. Someone just posted a utility and I am going to try that and report back. Thanks fo ryour response! "Judy Gleeson (MVP Outlook)" wrote: Can you describe the OUTCOME you want rather than the method that you think won't work. Then we can explain ways to go about achieveing what you want. Thanks Judy Gleeson MVP Outlook Outlook trainer and author of Productiv_IT with Outlook read my articles he www.judygleeson.com Canberra, Australia how to post questions: http://support.microsoft.com/?id=555375 "needs help badly!" wrote in message ... I know this is an old post but I'm having the same issue today with Outlook 2003. I checked out the utility posted by someone, but it seems that the utility requires a Microsoft Exchange Server (which I don't have) and may be geared for large corporate environments---I'm just a single user. Are there any known utilites for exporting the MAILING addresses from Outlook to Excel? The Mapping feature in Outlook shows Home address, business address and Other address, but does not allow one to chose the one that is the actual Mailing address for contacts that have multiple addresses. Please help! "desperate david" wrote: I have approx 1800 names & addresses in my Contacts. Most of these have more than one address. When displayed I have an option of ticking the Mailing Address. This is fine when doing a mail merge for a mailing. I am about to use a new company for mailing. They need my Mailing List in an Excel format. I know how to export to an Excel doc' but is does not let me chose the mailing address. this means that I will have to sift through 1800 address deleting as necessary. Does any kind soul know of a way round this? pretty please.
|
|
#4
August 2nd 07, 12:28 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
How can I select mailing address when exporting outlook to exc
I still ask WHY? What outcome are you aiming to get by sending it to Excel.
There may be ways to get what you want without sending it to Excel. Judy Gleeson MVP Outlook Outlook trainer and author of Productiv_IT with Outlook read my articles he www.judygleeson.com Canberra, Australia how to post questions: http://support.microsoft.com/?id=555375 "needs help badly!" wrote in message ... Hi Judy---I think the original poster stated the desired outcome clearly, and I have the same desired outcome. I.e. we want to export MAILING addresses from Outlook Contacts to Excel. I know how to export addresses, BUT most of my contacts have more than one address and I need to export the one that I have checked off indicating that it's the mailing address. Sometimes it's a home address, sometimes it's a business address and sometimes it something else (Other). But it is different for every contact. Someone just posted a utility and I am going to try that and report back. Thanks fo ryour response! "Judy Gleeson (MVP Outlook)" wrote: Can you describe the OUTCOME you want rather than the method that you think won't work. Then we can explain ways to go about achieveing what you want. Thanks Judy Gleeson MVP Outlook Outlook trainer and author of Productiv_IT with Outlook read my articles he www.judygleeson.com Canberra, Australia how to post questions: http://support.microsoft.com/?id=555375 "needs help badly!" wrote in message ... I know this is an old post but I'm having the same issue today with Outlook 2003. I checked out the utility posted by someone, but it seems that the utility requires a Microsoft Exchange Server (which I don't have) and may be geared for large corporate environments---I'm just a single user. Are there any known utilites for exporting the MAILING addresses from Outlook to Excel? The Mapping feature in Outlook shows Home address, business address and Other address, but does not allow one to chose the one that is the actual Mailing address for contacts that have multiple addresses. Please help! "desperate david" wrote: I have approx 1800 names & addresses in my Contacts. Most of these have more than one address. When displayed I have an option of ticking the Mailing Address. This is fine when doing a mail merge for a mailing. I am about to use a new company for mailing. They need my Mailing List in an Excel format. I know how to export to an Excel doc' but is does not let me chose the mailing address. this means that I will have to sift through 1800 address deleting as necessary. Does any kind soul know of a way round this? pretty please.
|
|
#5
August 2nd 07, 01:04 PM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
How can I select mailing address when exporting outlook to exc
I am uploading my mailing list to an online printer and they require the list
in csv or xls. "Judy Gleeson (MVP Outlook)" wrote: I still ask WHY? What outcome are you aiming to get by sending it to Excel. There may be ways to get what you want without sending it to Excel. Judy Gleeson MVP Outlook Outlook trainer and author of Productiv_IT with Outlook read my articles he www.judygleeson.com Canberra, Australia how to post questions: http://support.microsoft.com/?id=555375 "needs help badly!" wrote in message ... Hi Judy---I think the original poster stated the desired outcome clearly, and I have the same desired outcome. I.e. we want to export MAILING addresses from Outlook Contacts to Excel. I know how to export addresses, BUT most of my contacts have more than one address and I need to export the one that I have checked off indicating that it's the mailing address. Sometimes it's a home address, sometimes it's a business address and sometimes it something else (Other). But it is different for every contact. Someone just posted a utility and I am going to try that and report back. Thanks fo ryour response! "Judy Gleeson (MVP Outlook)" wrote: Can you describe the OUTCOME you want rather than the method that you think won't work. Then we can explain ways to go about achieveing what you want. Thanks Judy Gleeson MVP Outlook Outlook trainer and author of Productiv_IT with Outlook read my articles he www.judygleeson.com Canberra, Australia how to post questions: http://support.microsoft.com/?id=555375 "needs help badly!" wrote in message ... I know this is an old post but I'm having the same issue today with Outlook 2003. I checked out the utility posted by someone, but it seems that the utility requires a Microsoft Exchange Server (which I don't have) and may be geared for large corporate environments---I'm just a single user. Are there any known utilites for exporting the MAILING addresses from Outlook to Excel? The Mapping feature in Outlook shows Home address, business address and Other address, but does not allow one to chose the one that is the actual Mailing address for contacts that have multiple addresses. Please help! "desperate david" wrote: I have approx 1800 names & addresses in my Contacts. Most of these have more than one address. When displayed I have an option of ticking the Mailing Address. This is fine when doing a mail merge for a mailing. I am about to use a new company for mailing. They need my Mailing List in an Excel format. I know how to export to an Excel doc' but is does not let me chose the mailing address. this means that I will have to sift through 1800 address deleting as necessary. Does any kind soul know of a way round this? pretty please.
|
|
#6
August 2nd 07, 09:49 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
How can I select mailing address when exporting outlook to excel?
A simple free utility that will do what you're looking for is available
he http://www.codetwo.com/pages/freewar...ook_export.php Just pick the mailing address fields and save them to a CSV file (which you just need to open in Excel). Karl PS - If you need anything beyond the above - you're always welcome to check out our options which also handle the mailing address along with being able to split the street address into separate lines if required :-). __________________________________________________ _ 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 "needs help badly!" wrote in message ... I know this is an old post but I'm having the same issue today with Outlook 2003. I checked out the utility posted by someone, but it seems that the utility requires a Microsoft Exchange Server (which I don't have) and may be geared for large corporate environments---I'm just a single user. Are there any known utilites for exporting the MAILING addresses from Outlook to Excel? The Mapping feature in Outlook shows Home address, business address and Other address, but does not allow one to chose the one that is the actual Mailing address for contacts that have multiple addresses. Please help! "desperate david" wrote: I have approx 1800 names & addresses in my Contacts. Most of these have more than one address. When displayed I have an option of ticking the Mailing Address. This is fine when doing a mail merge for a mailing. I am about to use a new company for mailing. They need my Mailing List in an Excel format. I know how to export to an Excel doc' but is does not let me chose the mailing address. this means that I will have to sift through 1800 address deleting as necessary. Does any kind soul know of a way round this? pretty please.
|
|
#7
August 2nd 07, 11:40 AM
posted to microsoft.public.outlook.contacts
|
|||
|
|||
|
How can I select mailing address when exporting outlook to exc
Hi Karl---thanks for your response and the utility link. I just downloaded it
and will give it a try today. Will report back. Thank you!!! "Karl Timmermans" wrote: A simple free utility that will do what you're looking for is available he http://www.codetwo.com/pages/freewar...ook_export.php Just pick the mailing address fields and save them to a CSV file (which you just need to open in Excel). Karl PS - If you need anything beyond the above - you're always welcome to check out our options which also handle the mailing address along with being able to split the street address into separate lines if required :-). __________________________________________________ _ 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 "needs help badly!" wrote in message ... I know this is an old post but I'm having the same issue today with Outlook 2003. I checked out the utility posted by someone, but it seems that the utility requires a Microsoft Exchange Server (which I don't have) and may be geared for large corporate environments---I'm just a single user. Are there any known utilites for exporting the MAILING addresses from Outlook to Excel? The Mapping feature in Outlook shows Home address, business address and Other address, but does not allow one to chose the one that is the actual Mailing address for contacts that have multiple addresses. Please help! "desperate david" wrote: I have approx 1800 names & addresses in my Contacts. Most of these have more than one address. When displayed I have an option of ticking the Mailing Address. This is fine when doing a mail merge for a mailing. I am about to use a new company for mailing. They need my Mailing List in an Excel format. I know how to export to an Excel doc' but is does not let me chose the mailing address. this means that I will have to sift through 1800 address deleting as necessary. Does any kind soul know of a way round this? pretty please.
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Problems when exporting from Outlook to Excel | Increment | Outlook - Using Contacts | 7 | February 5th 10 04:11 PM |
| How to mail merge a mailing list from excel to outlook | julia | Outlook - General Queries | 4 | February 15th 07 09:55 AM |
| problems exporting from outlook to excel | greyhondo | Outlook - General Queries | 0 | February 7th 07 11:35 PM |
| email a mass mailing from an excel doc | KAT | Outlook - Using Contacts | 1 | August 26th 06 11:28 PM |
| Exporting my address book to excel | John Davy | Outlook - Using Contacts | 13 | May 18th 06 02:15 PM |
Hybrid Mode
