![]() |
| 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. |
|
|||||||
| Tags: america, contacts, remove, states, united |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
I have a large number of contacts that i have to put into excel and a lot of
them show up with "united states of america" as the country - even when they are not. how can i do this? Thanks |
| Ads |
|
#2
|
|||
|
|||
|
mrkmstrtt wrote:
I have a large number of contacts that i have to put into excel and a lot of them show up with "united states of america" as the country - even when they are not. how can i do this? Thanks Filter on the field and delete all the instances of USA.... |
|
#3
|
|||
|
|||
|
I am not sure what you mean by filter. Is this for outlook or for excel?
are there step-by-step directions? Thanks Gordon "Gordon" wrote: mrkmstrtt wrote: I have a large number of contacts that i have to put into excel and a lot of them show up with "united states of america" as the country - even when they are not. how can i do this? Thanks Filter on the field and delete all the instances of USA.... |
|
#4
|
|||
|
|||
|
do you need to remove them from excel or from outlook?
-- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook 2007: http://www.slipstick.com/outlook/ol2007/ Outlook Tips by email: Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Subscribe to Exchange Messaging Outlook newsletter: "mrkmstrtt" wrote in message ... I am not sure what you mean by filter. Is this for outlook or for excel? are there step-by-step directions? Thanks Gordon "Gordon" wrote: mrkmstrtt wrote: I have a large number of contacts that i have to put into excel and a lot of them show up with "united states of america" as the country - even when they are not. how can i do this? Thanks Filter on the field and delete all the instances of USA.... |
|
#6
|
|||
|
|||
|
you'll need to edit each one or use a VBA script to remove them in outlook.
see if outlookcode.com has any sample code. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook 2007: http://www.slipstick.com/outlook/ol2007/ Outlook Tips by email: Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Subscribe to Exchange Messaging Outlook newsletter: "mrkmstrtt" wrote in message ... i would like to remove them from outlook. thanks, diane "Diane Poremsky [MVP]" wrote: do you need to remove them from excel or from outlook? -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook 2007: http://www.slipstick.com/outlook/ol2007/ Outlook Tips by email: Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Subscribe to Exchange Messaging Outlook newsletter: "mrkmstrtt" wrote in message ... I am not sure what you mean by filter. Is this for outlook or for excel? are there step-by-step directions? Thanks Gordon "Gordon" wrote: mrkmstrtt wrote: I have a large number of contacts that i have to put into excel and a lot of them show up with "united states of america" as the country - even when they are not. how can i do this? Thanks Filter on the field and delete all the instances of USA.... |
|
#7
|
|||
|
|||
|
mrkmstrtt wrote:
I am not sure what you mean by filter. Is this for outlook or for excel? are there step-by-step directions? Excel. |
|
#8
|
|||
|
|||
|
I just had the same problem. Here's a solution I found on several web sites:
While in Outlook's contact list, change the view to "By Location" (View-Current View-By Location). Now select one or more of the contacts with USA in the "Country/Region" field and drag them to a contact with a blank "Country/Region" field. The "Country/Region" will be changed to blank, but the rest of the information will not be altered. You have to use the "By Location" view - sorting them by the country field in a different view won't work the same way! Good luck, Oscar "mrkmstrtt" wrote: I have a large number of contacts that i have to put into excel and a lot of them show up with "united states of america" as the country - even when they are not. how can i do this? Thanks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I stop Outlook adding "United States" to domestic contacts | Mike Harris | Outlook - Using Contacts | 9 | February 12th 08 02:01 AM |
| Delete "United States of America" from the Country/Region | ZZMHume | Outlook - General Queries | 4 | November 27th 07 08:24 PM |
| travel in the united states | roderick | Outlook Express | 6 | September 22nd 06 04:10 PM |
| How do I keep the "United States of America" out of contacts? | Knoxster | Outlook - Using Contacts | 1 | August 23rd 06 11:18 PM |
| Outlook Default Setting to Add United States of America at end of address | Jamess B. Holladay | Outlook - Using Contacts | 7 | February 11th 06 03:33 PM |