Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Telephone fields in Outlook 2007 (http://www.outlookbanter.com/outlook-vba/91296-telephone-fields-outlook-2007-a.html)

Marvin Buzz June 8th 09 03:26 AM

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.

Dmitry Streblechenko June 8th 09 08:20 AM

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.




Marvin Buzz June 9th 09 12:17 AM

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.





Ken Slovak - [MVP - Outlook] June 9th 09 01:57 PM

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.




All times are GMT +1. The time now is 11:13 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-2006 OutlookBanter.com