Textbox - Calculate Inititial Value

[Sydney]

HI all

I have an outlook form that contains a Contacts button and a text box that
sets the initial value as the contact name.
I have set the textbox value with the field [Contacts]. This perfectly
inserts the contact name chosen. I am also trying to insert the
BusinessTelephoneNumber but it doesnt seem to accept this.

What I have set in the textbox Value so far : [Contacts] &
[BusinessTelephoneNumber]

What am i doing wrong?

Many thanks.

 

[Sue Mosher [MVP-Outlook]]

Do you mean that you're trying to put in the phone number of the contact in the Contacts field? Outlook isn't a relational database with that kind of lookup capability. What you want to do would require VBSCript code behind the form that uses the Links collection to perform the lookup. For a VBA example that you can probably adapt, see http://www.outlookcode.com/codedetail.aspx?id=566


--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Sydney]

Oh I see. I was trying to steer away from vbscript but looks like i dont
have a choice

Thanks Sue.


Do you mean that you're trying to put in the phone number of the contact in
the Contacts field? Outlook isn't a relational database with that kind of
lookup capability. What you want to do would require VBSCript code behind
the form that uses the Links collection to perform the lookup. For a VBA
example that you can probably adapt, see
http://www.outlookcode.com/codedetail.aspx?id=566


--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers