Custom Meeting Request form
 

I want to customise the Meeting Request form. I have added a new Meeting
Request Form from Design Form section. In one of
the tabs (P.2) I have placed some controls (textbox, button,labels) and
"Required Attendees" field from Field Chooser options.
How can I add the VB code to the form to invoke the button click event and
populate the Required Attendees field ? When I do Alt + F11, am not able to
access the form elements.

Kindly let me know how to add code and populate the Required Attendees field
programatically.

Thanks in advance.
Regards
GSK

Custom Meeting Request form
 

Alt+F11 opens the VBA coding environment. Code on custom forms is not VBA, but VBScript. With the form in design mode, click the View Code button.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"GSK" wrote in message ...
I want to customise the Meeting Request form. I have added a new Meeting
Request Form from Design Form section. In one of
the tabs (P.2) I have placed some controls (textbox, button,labels) and
"Required Attendees" field from Field Chooser options.
How can I add the VB code to the form to invoke the button click event and
populate the Required Attendees field ? When I do Alt + F11, am not able to
access the form elements.

Kindly let me know how to add code and populate the Required Attendees field
programatically.

Thanks in advance.
Regards
GSK

Custom Meeting Request form
 

Thanks. But am not sure how to access the controls(buttons,textbox) in the
Script editor window. If you could provide some example it would be really
great.

Thanks and Regards
GSK

"Sue Mosher [MVP-Outlook]" wrote:

Alt+F11 opens the VBA coding environment. Code on custom forms is not VBA, but VBScript. With the form in design mode, click the View Code button.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"GSK" wrote in message ...
I want to customise the Meeting Request form. I have added a new Meeting
Request Form from Design Form section. In one of
the tabs (P.2) I have placed some controls (textbox, button,labels) and
"Required Attendees" field from Field Chooser options.
How can I add the VB code to the form to invoke the button click event and
populate the Required Attendees field ? When I do Alt + F11, am not able to
access the form elements.

Kindly let me know how to add code and populate the Required Attendees field
programatically.

Thanks in advance.
Regards
GSK

Custom Meeting Request form
 

You need to type in the complete procedure declaration for any Click event handlers, e.g.:

Sub CommandButton1_Click()
Msgbox "It works"
End Sub

For Item-level events, use the Script | Event Handler command.

The VBA environment is still useful, of course, for prototyping code and for looking up Outlook property names in the object browser.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"GSK" wrote in message ...
Thanks. But am not sure how to access the controls(buttons,textbox) in the
Script editor window. If you could provide some example it would be really
great.

Thanks and Regards
GSK

"Sue Mosher [MVP-Outlook]" wrote:

Alt+F11 opens the VBA coding environment. Code on custom forms is not VBA, but VBScript. With the form in design mode, click the View Code button.

"GSK" wrote in message ...
I want to customise the Meeting Request form. I have added a new Meeting
Request Form from Design Form section. In one of
the tabs (P.2) I have placed some controls (textbox, button,labels) and
"Required Attendees" field from Field Chooser options.
How can I add the VB code to the form to invoke the button click event and
populate the Required Attendees field ? When I do Alt + F11, am not able to
access the form elements.

Kindly let me know how to add code and populate the Required Attendees field
programatically.

Custom Meeting Request form
 

To start with I tried this in the P.2 form

Function Item_Open()
Msgbox "hi"
Item.GetInspector.ShowFormPage ("P.2")
Msgbox "hi"
End Function

Private Sub CommandButton2_Click()
Msgbox "hi"
End Sub

When I ran it, I am getting both the "Hi" messages but the P.2 form is not
selected.
When I go to P.2 form and click on the button, the message is not displayed.

Also please let me know would it be possible to a use
MAPI.Session/address/field and query the CdoPR_BUSINESS_ADDRESS_CITY value
and display in the controls.

THanks again.
GSK

"Sue Mosher [MVP-Outlook]" wrote:

You need to type in the complete procedure declaration for any Click event handlers, e.g.:

Sub CommandButton1_Click()
Msgbox "It works"
End Sub

For Item-level events, use the Script | Event Handler command.

The VBA environment is still useful, of course, for prototyping code and for looking up Outlook property names in the object browser.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"GSK" wrote in message ...
Thanks. But am not sure how to access the controls(buttons,textbox) in the
Script editor window. If you could provide some example it would be really
great.

Thanks and Regards
GSK

"Sue Mosher [MVP-Outlook]" wrote:

Alt+F11 opens the VBA coding environment. Code on custom forms is not VBA, but VBScript. With the form in design mode, click the View Code button.

"GSK" wrote in message ...
I want to customise the Meeting Request form. I have added a new Meeting
Request Form from Design Form section. In one of
the tabs (P.2) I have placed some controls (textbox, button,labels) and
"Required Attendees" field from Field Chooser options.
How can I add the VB code to the form to invoke the button click event and
populate the Required Attendees field ? When I do Alt + F11, am not able to
access the form elements.

Kindly let me know how to add code and populate the Required Attendees field
programatically.

Custom Meeting Request form
 

I just found the syntax issue and its working now the Form selection and
button click. But I still have the other question. Please let me know would
it be possible to a use
MAPI.Session/address/field and query the CdoPR_BUSINESS_ADDRESS_CITY value
and display in text field on click of button in the Custom form.

Thanks
GSK

"GSK" wrote:

To start with I tried this in the P.2 form

Function Item_Open()
Msgbox "hi"
Item.GetInspector.ShowFormPage ("P.2")
Msgbox "hi"
End Function

Private Sub CommandButton2_Click()
Msgbox "hi"
End Sub

When I ran it, I am getting both the "Hi" messages but the P.2 form is not
selected.
When I go to P.2 form and click on the button, the message is not displayed.

Also please let me know would it be possible to a use
MAPI.Session/address/field and query the CdoPR_BUSINESS_ADDRESS_CITY value
and display in the controls.

THanks again.
GSK

"Sue Mosher [MVP-Outlook]" wrote:

You need to type in the complete procedure declaration for any Click event handlers, e.g.:

Sub CommandButton1_Click()
Msgbox "It works"
End Sub

For Item-level events, use the Script | Event Handler command.

The VBA environment is still useful, of course, for prototyping code and for looking up Outlook property names in the object browser.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"GSK" wrote in message ...
Thanks. But am not sure how to access the controls(buttons,textbox) in the
Script editor window. If you could provide some example it would be really
great.

Thanks and Regards
GSK

"Sue Mosher [MVP-Outlook]" wrote:

Alt+F11 opens the VBA coding environment. Code on custom forms is not VBA, but VBScript. With the form in design mode, click the View Code button.

"GSK" wrote in message ...
I want to customise the Meeting Request form. I have added a new Meeting
Request Form from Design Form section. In one of
the tabs (P.2) I have placed some controls (textbox, button,labels) and
"Required Attendees" field from Field Chooser options.
How can I add the VB code to the form to invoke the button click event and
populate the Required Attendees field ? When I do Alt + F11, am not able to
access the form elements.

Kindly let me know how to add code and populate the Required Attendees field
programatically.

Custom Meeting Request form
 

For an Exchange user? Yes, it's possible using CDO 1.21 or, to avoid security prompts, Redemption (http://www.dimastr.com/redemption/). See http://www.outlookcode.com/codedetail.aspx?id=594 for Redemption sample code that's similar to what you might be thinking of.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"GSK" wrote in message ...
Please let me know would
it be possible to a use
MAPI.Session/address/field and query the CdoPR_BUSINESS_ADDRESS_CITY value
and display in text field on click of button in the Custom form.

Custom Meeting Request form
 

Thanks Sue.
In the Custom form I have added _RecipientControl1 field from the Field
chooser and renamed the Field name to RecipientControl1
I am not able to set the value for the field. THe below code doesn't work.
Please let me know how to set the value. What am currently trying to do is
based on the resource entered, identify the city where the User belongs to
and Query the Meeting Room in the city (meeting room is again an Outlook GAL
resource) and I want to populate the value to the Recipeitn Control.

Set objPage = Item.GetInspector.ModifiedFormPages("P.2")
Set objControl = objPage.Controls("RecipientControl1")
objControl.Value = "Meeting Room Austin"
Msgbox objControl.Value

Thanks
Siva

"Sue Mosher [MVP-Outlook]" wrote:

For an Exchange user? Yes, it's possible using CDO 1.21 or, to avoid security prompts, Redemption (http://www.dimastr.com/redemption/). See http://www.outlookcode.com/codedetail.aspx?id=594 for Redemption sample code that's similar to what you might be thinking of.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"GSK" wrote in message ...
Please let me know would
it be possible to a use
MAPI.Session/address/field and query the CdoPR_BUSINESS_ADDRESS_CITY value
and display in text field on click of button in the Custom form.

Custom Meeting Request form
 

That's the control that exposes the Recipients collection. You need to use that collection's methods, e.g. Recipients.Add, not try to write code for the control.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"GSK" wrote in message ...
Thanks Sue.
In the Custom form I have added _RecipientControl1 field from the Field
chooser and renamed the Field name to RecipientControl1
I am not able to set the value for the field. THe below code doesn't work.
Please let me know how to set the value. What am currently trying to do is
based on the resource entered, identify the city where the User belongs to
and Query the Meeting Room in the city (meeting room is again an Outlook GAL
resource) and I want to populate the value to the Recipeitn Control.

Set objPage = Item.GetInspector.ModifiedFormPages("P.2")
Set objControl = objPage.Controls("RecipientControl1")
objControl.Value = "Meeting Room Austin"
Msgbox objControl.Value

Thanks
Siva

"Sue Mosher [MVP-Outlook]" wrote:

For an Exchange user? Yes, it's possible using CDO 1.21 or, to avoid security prompts, Redemption (http://www.dimastr.com/redemption/). See http://www.outlookcode.com/codedetail.aspx?id=594 for Redemption sample code that's similar to what you might be thinking of.


"GSK" wrote in message ...
Please let me know would
it be possible to a use
MAPI.Session/address/field and query the CdoPR_BUSINESS_ADDRESS_CITY value
and display in text field on click of button in the Custom form.