![]() |
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. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
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. |
Ads |
#2
|
|||
|
|||
![]()
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 -- 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/ "GSK" wrote: 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. |
#3
|
|||
|
|||
![]()
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 "Eric Legault [MVP - Outlook]" wrote: 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 -- 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/ "GSK" wrote: 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. |
#4
|
|||
|
|||
![]()
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? -- 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/ "GSK" wrote: 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 "Eric Legault [MVP - Outlook]" wrote: 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 -- 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/ "GSK" wrote: 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. |
#5
|
|||
|
|||
![]()
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 "Eric Legault [MVP - Outlook]" wrote: 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? -- 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/ "GSK" wrote: 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 "Eric Legault [MVP - Outlook]" wrote: 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 -- 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/ "GSK" wrote: 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. |
#6
|
|||
|
|||
![]()
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. -- 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/ "GSK" wrote: 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 "Eric Legault [MVP - Outlook]" wrote: 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? -- 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/ "GSK" wrote: 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 "Eric Legault [MVP - Outlook]" wrote: 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 -- 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/ "GSK" wrote: 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. |
#7
|
|||
|
|||
![]()
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 "Eric Legault [MVP - Outlook]" wrote: 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. -- 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/ "GSK" wrote: 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 "Eric Legault [MVP - Outlook]" wrote: 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? -- 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/ "GSK" wrote: 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 "Eric Legault [MVP - Outlook]" wrote: 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 -- 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/ "GSK" wrote: 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. |
#8
|
|||
|
|||
![]()
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. -- 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/ "GSK" wrote: 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 "Eric Legault [MVP - Outlook]" wrote: 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. -- 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/ "GSK" wrote: 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 "Eric Legault [MVP - Outlook]" wrote: 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? -- 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/ "GSK" wrote: 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 "Eric Legault [MVP - Outlook]" wrote: 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 -- 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/ "GSK" wrote: 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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Best way to move scheduling from Public Folders to Resource Scheduling | Sulfurious@gmail.com | Outlook - General Queries | 1 | June 10th 07 03:25 PM |
HOW CAN I MAKE APPOITMENT WITHOUT E-MAIL | tepuyo2002 | Outlook - Calandaring | 1 | February 13th 07 12:02 AM |
Before inserting appointment how to find already appoitment exits | ShilpaM | Outlook - Calandaring | 5 | May 17th 06 01:34 PM |
Outlook appoitment strange E-mail | Sue Mosher [MVP-Outlook] | Outlook - Calandaring | 0 | January 25th 06 07:24 PM |
Customize Outlook 2000 | Brenda Heideloff | Outlook - General Queries | 1 | January 18th 06 03:19 PM |