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