MartyConnelly
martyconnelly at shaw.ca
Tue Jan 3 13:03:46 CST 2006
Maybe look through the links starting here http://www.slipstick.com/config/ukbignumber.htm Probably to do with one of these settings in Outlook enter telephone numbers in full "international" or "canonical" format: +xx (yyy) zzzz-zzzz and Telephony applet from Control Panel which determines your present phone location Erwin Craps - IT Helps wrote: >Euh yes, >but thats not the issue. > >If I do >Contactitem.PhoneNumber ="+3216296404" >Debug.print Contactitem.PhoneNumber > >I get "+32 16296404" as result > >Outlook autmaticaly adds a space. > > > >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of >DWUTKA at marlow.com >Sent: Tuesday, January 03, 2006 3:28 PM >To: accessd at databaseadvisors.com >Subject: Re: [AccessD] Saving Phonenumber format in Outlook > >Is the Replace function not working? >SomeString=Replace(StringWithPhoneNumber," ","") > >Drew > > -----Original Message----- > From: Erwin Craps - IT Helps [SMTP:Erwin.Craps at ithelps.be] > Sent: Tuesday, January 03, 2006 3:40 AM > To: accessd at databaseadvisors.com > Subject: [AccessD] Saving Phonenumber format in Outlook > > > Hapyy New Year to you all. > May your wishes (and mine) come true :-) > > Here's my question. > > I'm using in VBA the ContactItem object to save or edit a >phonenumber > from a contact. > > I set my phonenumber in international format so when I >synchronyse my > Outlook contacts with my GSM/Mobile phone I can dial from any >country. > > As you now the international format is > + sign (international dialing) - country code - zone (without >leading > zero) - phonenumber. > Example: +3216296404 > > When setting a contact phonenumber to "+3216296404" outlook >changes it > to "+32 16296404" with a space between the country code and > zone+phonenumber. > > Whats the big deal you would say, well the problem is that it >also > synchonyses that way to my mobile phone. > This is not a problem for dialing out, but when when someone >calls me, > the incoming phonenumber is not recognised in the mobiles >database due > to that added space. > > Is there a way I can make Outlook save the phonenumber without >that > space. > I can remove the space when having a linked table in Access to >Outlook, > So why can I not remove thet space from within VBA? > > > > > > Erwin Craps > > Zaakvoerder > > www.ithelps.be/onsgezin > > > > This E-mail is confidential, may be legally privileged, and is >for the > intended recipient only. Access, disclosure, copying, >distribution, or > reliance on any of it by anyone else is prohibited and may be a >criminal > offence. Please delete if obtained in error and E-mail >confirmation to > the sender. > > IT Helps - I.T. Help Center *** Box Office Belgium & >Luxembourg > > www.ithelps.be <http://www.ithelps.be/> * www.boxoffice.be > <http://www.boxoffice.be/> * www.stadleuven.be > <http://www.stadleuven.be/> > > IT Helps bvba* ** Mercatorpad 3 ** 3000 Leuven > > IT Helps * Phone: +32 16 296 404 * Fax: +32 16 296 405 >E-mail: > Info at ithelps.be > > Box Office ** Fax: +32 16 296 406 ** Box Office E-mail: > Staff at boxoffice.be <mailto:figures at boxoffice.be> > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com > > -- Marty Connelly Victoria, B.C. Canada