PC Review


Reply
Thread Tools Rate Thread

how do i format phone number field

 
 
=?Utf-8?B?dG5idWJiYQ==?=
Guest
Posts: n/a
 
      1st May 2006
I have imported my Act 2000 database into Outlook 2003 to begin my conversion
process. Even though I did not have the 1+ dialing in act..Outlook 2003 it
added it to all my phone number fields. How do I bulk format all existing
phone number fileds to read only (xxx) 555-1212??
 
Reply With Quote
 
 
 
 
Brian Tillman
Guest
Posts: n/a
 
      1st May 2006
tnbubba <(E-Mail Removed)> wrote:

> I have imported my Act 2000 database into Outlook 2003 to begin my
> conversion process. Even though I did not have the 1+ dialing in
> act..Outlook 2003 it added it to all my phone number fields. How do
> I bulk format all existing phone number fileds to read only (xxx)
> 555-1212??


See if this helps:
While viewing Contacts, click Actions>Call Contact>New Call. Click Dialing
Options and uncheck "Automatically add country code to local phone numbers".
I don't believe that will affect numbers already formatted with the country
code, but it should supporess future addition. However, the coutry code is
proper and there should be no issue with leaving it. It is canonical.

You can use this tool to remove existing country codes if you wish:
http://www.slovaktech.com/phonechanger.htm
--
Brian Tillman

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format Phone Number Field VBA Tony Microsoft Excel Misc 2 22nd May 2009 09:17 PM
Format Phone Number Field VBA Tony Microsoft Excel Misc 0 22nd May 2009 08:55 PM
Format form field for phone number Nina Microsoft Word Document Management 2 10th Apr 2009 09:58 PM
form field format for phone number =?Utf-8?B?SmFu?= Microsoft Word Document Management 4 9th Mar 2007 04:18 AM
How do I display a phone number format from a text field? =?Utf-8?B?QkJkb2xs?= Microsoft Access Reports 4 22nd Mar 2005 06:11 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:01 PM.