How can I remove "United States of America" from contacts?

  • Thread starter Thread starter mrkmstrtt
  • Start date Start date
M

mrkmstrtt

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
 
mrkmstrtt said:
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
Click to expand...

Filter on the field and delete all the instances of USA....
 
I am not sure what you mean by filter. Is this for outlook or for excel?
are there step-by-step directions?

Thanks Gordon
 
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.
 
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
 
I know I'm 2.5 years late, but THANK YOU!
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....
Click to expand...
Click to expand...
 
I'm also 2.5 years late... but, yes, THANKS for this!
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....
Click to expand...
Click to expand...
 
Make it an even 3 years for me. Thanks!
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....
Click to expand...
Click to expand...
 
Back
Top