[AccessD] Saving Phonenumber format in Outlook

Hmmm, don't mess around with Outlook too much, but I would think there would
be somewhere to set the format for phone numbers.

Drew

	-----Original Message-----
	From:	Erwin Craps - IT Helps [SMTP:Erwin.Craps at ithelps.be]
	Sent:	Tuesday, January 03, 2006 9:18 AM
	To:	Access Developers discussion and problem solving
	Subject:	Re: [AccessD] Saving Phonenumber format in Outlook

	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
	-- 
	AccessD mailing list
	AccessD at databaseadvisors.com
	http://databaseadvisors.com/mailman/listinfo/accessd
	Website: http://www.databaseadvisors.com