 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / April 2008How can I remove "United States of America" from contacts?
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 > 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.... I am not sure what you mean by filter. Is this for outlook or for excel? are there step-by-step directions? 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 [quoted text clipped - 3 lines] > > Filter on the field and delete all the instances of USA.... do you need to remove them from excel or from outlook?  SignatureDiane 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-subscribe-request@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-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM >I am not sure what you mean by filter. Is this for outlook or for excel? > are there step-by-step directions? [quoted text clipped - 10 lines] >> >> Filter on the field and delete all the instances of USA.... i would like to remove them from outlook. thanks, diane > do you need to remove them from excel or from outlook? > [quoted text clipped - 12 lines] > >> > >> Filter on the field and delete all the instances of USA.... 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. SignatureDiane 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-subscribe-request@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-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM >i would like to remove them from outlook. > [quoted text clipped - 19 lines] >> >> >> >> 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? Excel. 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 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 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.