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

[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

 

[Gordon]

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

 

[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

 

[Diane Poremsky [MVP]]

do you need to remove them from excel or from outlook?

 

[mrkmstrtt]

i would like to remove them from outlook.

thanks, diane

 

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

 

[Gordon]

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

Excel.

 

[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

 

[Terrance]

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.

 

[Diane Poremsky [Outlook MVP]]

It works here. Are you using the By location button and showing in
groups? Straight "By location" is not grouped - you need to group by
location.


Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/
OutlookForums http://www.outlookforums.com