Customize outlook appoitment scheduling

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GSK - 06 Sep 2007 00:30 GMT

In Outlook 2003, Under Calendar - > New Appoitment -> Scheduling, I wanto to
add a custom button, invoke a custom form on clicking the button where user
filter the outlook resources based on City /Last Name, FirstName and when
selecting a resource it should populate it under the "All Attendees" in
scheduling window.
Briefly my doubts are :
1. How to add a custom button to the outlook scheduling page.
2. On selecting a resouce how to populate it back to scheduling page.
Thanks in advance.

Reply to this Message

Eric Legault [MVP - Outlook] - 06 Sep 2007 18:56 GMT

Unfortunately, you cannot customize the Scheduling page on a Meeting Request
form. But once you build your form to present the user with a display of
resources to choose from, you can create an instance of your custom form by
adding an instance of it to the Items collection for the folder where the
form is published:

Set objMyForm = objMyFolder.Items.Add("IPM.MyCustomForm")
objMyForm.Display

"Dialog" forms like the one you describe for your solution don't need to be
saved, so technically you aren't adding anything to the collection.

So once the user has made their selection, you can take the selected
resource names and add them to a Recipients collection like the following
example from Outlook VBA Help:

Set myItem = myOlApp.CreateItem(olAppointmentItem)
myItem.MeetingStatus = olMeeting
myItem.Subject = "Strategy Meeting"
myItem.Location = "Conference Room B"
myItem.Start = #9/24/97 1:30:00 PM#
myItem.Duration = 90
Set myRequiredAttendee = myItem.Recipients.Add("Nate _
Sun")
myRequiredAttendee.Type = olRequired
Set myOptionalAttendee = myItem.Recipients.Add("Kevin _
Kennedy")
myOptionalAttendee.Type = olOptional
Set myResourceAttendee = _
myItem.Recipients.Add("Conference Room B")
myResourceAttendee.Type = olResource
myItem.Send

Signature

Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/

> In Outlook 2003, Under Calendar - > New Appoitment -> Scheduling, I wanto to
> add a custom button, invoke a custom form on clicking the button where user
[quoted text clipped - 5 lines]
> 2. On selecting a resouce how to populate it back to scheduling page.
> Thanks in advance.

Reply to this Message

GSK - 01 Oct 2007 22:06 GMT

Hi Eric, Thanks for your reply.
I want to use the existing Outlook appointment and scheduling page and we
want to build some custom search on top of it i.e to filter the Meeting rooms
based on the entity resource location. Will it be possible to create a tab in
the appointment form? Or any other way of integrating this custom
implementation in the existing outlook appointment/scheduling form?
Thanks in advance.

Regards,
GSK

> Unfortunately, you cannot customize the Scheduling page on a Meeting Request
> form. But once you build your form to present the user with a display of
[quoted text clipped - 38 lines]
> > 2. On selecting a resouce how to populate it back to scheduling page.
> > Thanks in advance.

Reply to this Message

Eric Legault [MVP - Outlook] - 02 Oct 2007 02:09 GMT

You can most certainly add a few custom tabs on an Appointment form to
implement whatever UI you want. Are you just trying to confirm that this is
possible?

Signature

Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/

> Hi Eric, Thanks for your reply.
> I want to use the existing Outlook appointment and scheduling page and we
[quoted text clipped - 49 lines]
> > > 2. On selecting a resouce how to populate it back to scheduling page.
> > > Thanks in advance.

Reply to this Message

GSK - 02 Oct 2007 02:58 GMT

Thanks Eric. Initially I was just trying to confirm whether is't possible to
add custom tab to the existing Meeting form. As you have said "yes" I will
try creating a tab page.
Could you please tell me know whether I can do the following in Custom tab
- Adding controls like textbox,button and clicking the button query the
resource address details from GAL.
I have one more question
I have already written a vb application which uses CDO objects and query the
address details from GAL for an entity. But I found it takes very long time
to query and in Outlook direct mail query (entering the name and Ctrl +K) its
much faster.
Could you please let me know how to improve the query speed.
Thanks very much for your advice and support.

Regards
GSK

> You can most certainly add a few custom tabs on an Appointment form to
> implement whatever UI you want. Are you just trying to confirm that this is
[quoted text clipped - 53 lines]
> > > > 2. On selecting a resouce how to populate it back to scheduling page.
> > > > Thanks in advance.

Reply to this Message

Eric Legault [MVP - Outlook] - 02 Oct 2007 03:43 GMT

All of the controls you mention can be used on a custom Outlook form - take a
look at what is in the toolbox. You can also insert just about any ActiveX
control that is registered on your development computer.

If you want to resolve a recipient, take a look at Recipient.Resolve method
- this can't get any faster as it utilizes the same "CTRL+K" lookup that
Outlook uses. No CDO required, unless you need to get properties for an
address in the GAL other than name or e-mail.

Signature

Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/

> Thanks Eric. Initially I was just trying to confirm whether is't possible to
> add custom tab to the existing Meeting form. As you have said "yes" I will
[quoted text clipped - 70 lines]
> > > > > 2. On selecting a resouce how to populate it back to scheduling page.
> > > > > Thanks in advance.

Reply to this Message

GSK - 15 Oct 2007 21:35 GMT

Thanks Eric.
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 very much for your help and support.

Regards,
GSK

> All of the controls you mention can be used on a custom Outlook form - take a
> look at what is in the toolbox. You can also insert just about any ActiveX
[quoted text clipped - 79 lines]
> > > > > > 2. On selecting a resouce how to populate it back to scheduling page.
> > > > > > Thanks in advance.

Reply to this Message

Eric Legault [MVP - Outlook] - 29 Oct 2007 17:51 GMT

ALT+F11 is actually the shortcut for the VBA editor. However, you need to
use the Script Editor for custom forms. You will need to create a procedure
for the button:

Sub Button1_Click()

End Sub

Then add code to read the value of your combo box. If your control is bound
to a custom field, you can read the value like this:

myValue = Item.UserProperties("MyField").Value

I'm guessing you will then need to use this value to create a recipient - so
use the Recipients.Add method to add it to the collection.

Signature

Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/

> Thanks Eric.
> I have added a new Meeting Request Form from Design Form section. In one of
[quoted text clipped - 95 lines]
> > > > > > > 2. On selecting a resouce how to populate it back to scheduling page.
> > > > > > > Thanks in advance.

Reply to this Message