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

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
 
G

Gordon

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

Filter on the field and delete all the instances of USA....
 
M

mrkmstrtt

I am not sure what you mean by filter. Is this for outlook or for excel?
are there step-by-step directions?

Thanks Gordon
 
D

Diane Poremsky [MVP]

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.
 
O

Oscar Fowler

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
 
T

Terrance

Oscar said:
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

Hello,

I'm almost 4 years late, but with Office 2010, I am unable to use the this
method with any success. Copying one or many contacts to a contact with a
blank country/region is not permitted (the "not-allowed" pictogram appears
as I am dragging the contacts).

I hope someone out there can help put me on the right path.

Thank you.
Terrance.
 

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