Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

827 views
Skip to first unread message

Oscar Fowler

unread,
Apr 28, 2008, 10:36:01 AM4/28/08
to
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

Maisie Walton

unread,
Nov 10, 2010, 1:35:55 PM11/10/10
to
I know I'm 2.5 years late, but THANK YOU!

> On Monday, March 10, 2008 11:08 AM mrkmstrt 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


>> On Monday, March 10, 2008 11:18 AM Gordon wrote:

>> mrkmstrtt wrote:
>>
>> Filter on the field and delete all the instances of USA....


>>> On Monday, March 10, 2008 12:45 PM mrkmstrt wrote:

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


>>>> On Monday, March 10, 2008 12:52 PM 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:
>>>> dailytips-sub...@lists.outlooktips.net
>>>>
>>>> Outlook Tips: http://www.outlook-tips.net/
>>>> Outlook & Exchange Solutions Center: http://www.slipstick.com
>>>> Subscribe to Exchange Messaging Outlook newsletter:
>>>> EMO-NEWSLETTER-S...@PEACH.EASE.LSOFT.COM
>>>>
>>>>
>>>> "mrkmstrtt" <mrkm...@discussions.microsoft.com> wrote in message
>>>> news:26985D19-8893-46E8...@microsoft.com...


>>>>> On Monday, March 10, 2008 12:56 PM mrkmstrt wrote:

>>>>> i would like to remove them from outlook.
>>>>>
>>>>> thanks, diane
>>>>> "Diane Poremsky [MVP]" wrote:


>>>>>> On Monday, March 10, 2008 2:02 PM Diane Poremsky [MVP] wrote:

>>>>>> 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:
>>>>>> dailytips-sub...@lists.outlooktips.net
>>>>>>
>>>>>> Outlook Tips: http://www.outlook-tips.net/
>>>>>> Outlook & Exchange Solutions Center: http://www.slipstick.com
>>>>>> Subscribe to Exchange Messaging Outlook newsletter:
>>>>>> EMO-NEWSLETTER-S...@PEACH.EASE.LSOFT.COM
>>>>>>
>>>>>>
>>>>>> "mrkmstrtt" <mrkm...@discussions.microsoft.com> wrote in message
>>>>>> news:EBECC3A1-4BB7-4ACA...@microsoft.com...


>>>>>>> On Monday, March 10, 2008 2:06 PM Gordon wrote:

>>>>>>> mrkmstrtt wrote:
>>>>>>>
>>>>>>> Excel.


>>>>>>>> On Monday, April 28, 2008 10:36 AM OscarFowle wrote:

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


>>>>>>>> Submitted via EggHeadCafe
>>>>>>>> Visual Studio Async CTP Overview
>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/e78665f9-b949-4cc7-a024-654eb3bbad6d/visual-studio-async-ctp-overview.aspx

Palm Champion

unread,
Dec 22, 2010, 2:06:41 PM12/22/10
to
I'm also 2.5 years late... but, yes, THANKS for this!

>>>>>>> mrkmstrtt wrote:
>>>>>>>
>>>>>>> Excel.


>>>>>>>>> On Wednesday, November 10, 2010 1:35 PM Maisie Walton wrote:

>>>>>>>>> I know I'm 2.5 years late, but THANK YOU!


>>>>>>>>>> On Wednesday, December 22, 2010 2:05 PM Palm Champion wrote:

>>>>>>>>>> I'm also 2.5 years late... but, yes, THANKS for this!


>>>>>>>>>> Submitted via EggHeadCafe
>>>>>>>>>> Microsoft ASP.NET For Beginners
>>>>>>>>>> http://www.eggheadcafe.com/training-topic-area/ASP-NET/7/ASP.aspx

Chris Tremayne

unread,
May 6, 2011, 3:42:32 AM5/6/11
to
Make it an even 3 years for me. Thanks!

Terrance

unread,
Oct 26, 2011, 4:40:35 AM10/26/11
to
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.

--

______________________________________
Posted from http://outlook-center.com
Outlook forums, articles, tips.

Diane Poremsky [Outlook MVP]

unread,
Oct 28, 2011, 8:26:30 AM10/28/11
to
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 Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
OutlookForums http://www.outlookforums.com
0 new messages