Outlook 2000 contacts formatting when importing

[cjhowell]

Hi,

I'm working on a project where users are migrating from a standard
mobile to a Blackberry device. As part of the migration, contact
details stored on the mobile are extracted to a tab delimited file for
import into Outlook 2000.

There are 2 issues with the import of data into Outlook:

- The default setting in Outlook is to display a contact name as First
Name Last Name. On import from the above file, this formatting is not
applied.

- Outlook is formatting phone numbers which become unusable on the
Blackberry because of the () and - that Outlook inserts.

Is there any way to:

- Force outlook to format the name correctly for all contacts without
editing each record?

- How can the phone number be updated without Outlook overriding this
and making the number unusable again?

It looks like part of the problem is that Outlook is trying to identify
area codes. This is fine for local numbers (Sydney/02) but it is also
stripping mobile numbers.

Thanks,

Chris

 

[Russ Valentine [MVP-Outlook]]

Formatting of the File As.. field will not apply to imported Contacts. You
can run code to reset them afterwards if you want.
Masking of phone numbers in Outlook is hard coded and cannot be overridden.
Sometimes you can prevent automatic masking by spoofing a null dialing
location, but most OS won't let you do that.

 

[cjhowell]

Formatting of the File As.. field will not apply to imported Contacts. You

can run code to reset them afterwards if you want.

Hi, are you able to point to where I can obtain this code?

Thanks

 

[Russ Valentine [MVP-Outlook]]

Sure.
http://support.microsoft.com/default.aspx?scid=kb;en-us;291144&Product=ol2002