A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Telephone fields in Outlook 2007



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old June 8th 09, 03:26 AM posted to microsoft.public.outlook.program_vba
Marvin Buzz
external usenet poster
 
Posts: 9
Default Telephone fields in Outlook 2007

I run Outlook 2007 on my local PC, no exchange server is involved. Using VB,
I want to look at all of the phone and fax fields of each contact. I can
find no doc re the field names that I can use in my VB program. Any help
would be appreciated.

Thanks.
Ads
  #2  
Old June 8th 09, 08:20 AM posted to microsoft.public.outlook.program_vba
Dmitry Streblechenko
external usenet poster
 
Posts: 2,116
Default Telephone fields in Outlook 2007

Object Browser in VBA is your friend (Alt + F11).
Off the top of my head, the following will be usefuil: BusinessFaxNumber,
BusinessTelephoneNumber, CallbackTelephoneNumber, CarTelephoneNumber,
CompanyMainTelephoneNumber, Home2TelephoneNumber, HomeTelephoneNumber,
MobileTelephoneNumber, OtherFaxNumber, OtherTelephoneNumber,
RadioTelephoneNumber./

You can also look at a contact with OutlookSpy (url below, select a contact
and click the Item button)

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"Marvin Buzz" wrote in message
...
I run Outlook 2007 on my local PC, no exchange server is involved. Using
VB,
I want to look at all of the phone and fax fields of each contact. I can
find no doc re the field names that I can use in my VB program. Any help
would be appreciated.

Thanks.



  #3  
Old June 9th 09, 12:17 AM posted to microsoft.public.outlook.program_vba
Marvin Buzz
external usenet poster
 
Posts: 9
Default Telephone fields in Outlook 2007

Thank you. I have found those fields and they contain what I need. If my
contact item is named cont then I would reference an item as
cont.HomeTelephoneNumber for example. If I have a variable that has a value
of "HomeTelephoneNumber" how would I reference the field? cont.variablename
does not work.

"Dmitry Streblechenko" wrote:

Object Browser in VBA is your friend (Alt + F11).
Off the top of my head, the following will be usefuil: BusinessFaxNumber,
BusinessTelephoneNumber, CallbackTelephoneNumber, CarTelephoneNumber,
CompanyMainTelephoneNumber, Home2TelephoneNumber, HomeTelephoneNumber,
MobileTelephoneNumber, OtherFaxNumber, OtherTelephoneNumber,
RadioTelephoneNumber./

You can also look at a contact with OutlookSpy (url below, select a contact
and click the Item button)

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"Marvin Buzz" wrote in message
...
I run Outlook 2007 on my local PC, no exchange server is involved. Using
VB,
I want to look at all of the phone and fax fields of each contact. I can
find no doc re the field names that I can use in my VB program. Any help
would be appreciated.

Thanks.




  #4  
Old June 9th 09, 01:57 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default Telephone fields in Outlook 2007

You have to specify the object property name, you can't use a variable for
that. You'd have to set up a set of if blocks or a case block and test the
value of your variable and then access the property by name depending on the
value of your variable.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Marvin Buzz" wrote in message
...
Thank you. I have found those fields and they contain what I need. If my
contact item is named cont then I would reference an item as
cont.HomeTelephoneNumber for example. If I have a variable that has a
value
of "HomeTelephoneNumber" how would I reference the field?
cont.variablename
does not work.


 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Ensuring e.164 compliance in Telephone Number fields Henry Goodrow Outlook - Using Forms 1 October 29th 08 01:47 PM
Telephone Fields in Conatct Jim R Outlook - Using Forms 5 September 3rd 08 08:55 PM
Disabling Telephone Dialling in Outlook 2007 VistaStruggle Outlook - Using Contacts 5 June 19th 08 10:00 PM
Auto Formatting telephone number fields in Outlook letisia Outlook - Using Contacts 6 March 6th 08 07:06 PM
Auto Formatting telephone number fields Shoe Outlook - Using Contacts 1 February 24th 08 03:31 AM


All times are GMT +1. The time now is 11:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.