Problem with Company names starting with "LA" or "LE"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
Karl Timmermans said:
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
 
I have the same problem with company names that begin with "El". Thanks for
providing instructions for fixing the problem.
 
Back
Top