 |
 | 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 / March 2006Problem with Company names starting with "LA" or "LE"
When I create a new contact in Outlook 2000, and enter in a company name starting with "LA" or "LE", Outlook rewrites the company name and takes the "LA" or "LE" and moves it to the end of the company preceded by a comma. I assume it thinks "LA" or "LE" is the French equivalent of "The". In reality, the "LA" in these contacts stands for "Los Angeles" and I don't want this to happen. I am actually using a VBA script to import contact records from my Access 2000 database to a contacts folder in my Outlook PST when this happens, so it would be a real pain to go back in and edit each of the misnamed companies. Is there some way to simply turn this feature off? There are four words that cause the action you describe (at least the only ones we've found so far) - these are The, Le, La, El This transposition only occurs when you initially "add" a new contact and there's no way to turn that off that we're aware of BUT what you can do is save your contact and then update the name field with the same value - no transposition occurs when "changing" the company name. In your case since you already are using VBA - just need to check the name field and proceed accordingly. Karl __________________________________________ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 "Power contact importers for MS Outlook '2000/2003" http://www.contactgenie.com > When I create a new contact in Outlook 2000, and enter in a company name > starting with "LA" or "LE", Outlook rewrites the company name and takes [quoted text clipped - 10 lines] > happens, so it would be a real pain to go back in and edit each of the > misnamed companies. Is there some way to simply turn this feature off? > There are four words that cause the action you describe (at least the only > ones we've found so far) - these are [quoted text clipped - 30 lines] > > happens, so it would be a real pain to go back in and edit each of the > > misnamed companies. Is there some way to simply turn this feature off? I have the same problem with company names that begin with "El". Thanks for providing instructions for fixing the problem. > There are four words that cause the action you describe (at least the only > ones we've found so far) - these are [quoted text clipped - 30 lines] > > happens, so it would be a real pain to go back in and edit each of the > > misnamed companies. Is there some way to simply turn this feature off? In OL 2003 I get the same thing when I enter the company name as something starting with LA Test, as in Los Angeles. In File As it shows up as Test, LA and offers no correct option. However I found that if I have the File As window open I can type the correct name and it "sticks." Joe McGuire > When I create a new contact in Outlook 2000, and enter in a company name > starting with "LA" or "LE", Outlook rewrites the company name and takes [quoted text clipped - 10 lines] > happens, so it would be a real pain to go back in and edit each of the > misnamed companies. Is there some way to simply turn this feature off? Not sure what you mean by a "correction option". Actually what you'll find is that if you enter the company name "La Test" in a brand new contact - it will transpose. If you enter the exact same name a second time in the company name field - it won't. Best we can surmise is that the formatting rules only apply when the data is "first entered" into the field and ignores the rule for any subsequent changes whether the contact has been saved or not. The second change to the CompanyName field will also be reflected in the FileAs field providing that you have not made a change to the FileAs field directly in which case it won't matter what changes you make to the CompanyName field. If you don't make a direct change to the FileAs field - then all changes to the CompanyName field will get reflected in the FileAs field regardless of how many changes you make to CompanyName. Or to put it another way, if you change the "File As" field manually - the change will stick to it but will not change the value in the CompanyName field and will not be affected by anything entered in future in the CompanyName field. In short, trying to keep track of how Outlook handles data for some of these fields across various versions can become an interesting exercise since not all versions between O'2000 and O'2003 do the same thing for the same fields. Karl __________________________________________ Karl Timmermans - The Claxton Group ContactGenie - Importer 1.3 / DataPorter 2.0 "Power contact importers for MS Outlook '2000/2003" http://www.contactgenie.com > In OL 2003 I get the same thing when I enter the company name as something > starting with LA Test, as in Los Angeles. In File As it shows up as Test, [quoted text clipped - 17 lines] >> happens, so it would be a real pain to go back in and edit each of the >> misnamed companies. Is there some way to simply turn this feature off?
|
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
|
©2008 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.