Given my lack of proficiency with VBScripting, I’m turning to the pros out there!
I have created an Outlook 2010 custom form based on the Appointment template. I have renamed the P.2 tab to “Activity” and published it, for now, in the Personal Forms Library. This form will need to work with Outlook 2007 too.
On the Activity tab space, I have created 2 combo boxes (cbxSystem and cbxSchool) and a check box (chkTest). Each of those is bound to a corresponding field label.
I have set up an Excel sheet with the following layout (230 different schools in 21 different systems):
----System-----|----School-----|----Test-----|
-----111-------|------A1-------|------N------|
-----111-------|------B1-------|------Y------|
-----111-------|------C1-------|------N------|
-----112-------|------A2-------|------N------|
-----112-------|------B2-------|------Y------|
-----113-------|------A3-------|------N------|
-----113-------|------B3-------|------N------|
-----113-------|------C3-------|------Y------|
-----113-------|------D3-------|------Y------|
-----113-------|------E3-------|------N------|
I have defined names corresponding to the column headers for each range of data.
My dilemma is to populate cbxSystem, and depending on the user selection, cbxSchool would be populated with the available data for that system. Also, depending on the chosen school, chkTest would be checked if the Test value is Y… There are a few other text fields on the form and, when completed, the user would click a “Submit” button and it would create a calendar entry for the selected date and times.
The data doesn’t need to be in an Excel file, anything will do…
Sure hope that someone can get me on the right track!
Thanks…
Dave
I have created an Outlook 2010 custom form based on the Appointment template. I have renamed the P.2 tab to “Activity” and published it, for now, in the Personal Forms Library. This form will need to work with Outlook 2007 too.
On the Activity tab space, I have created 2 combo boxes (cbxSystem and cbxSchool) and a check box (chkTest). Each of those is bound to a corresponding field label.
I have set up an Excel sheet with the following layout (230 different schools in 21 different systems):
----System-----|----School-----|----Test-----|
-----111-------|------A1-------|------N------|
-----111-------|------B1-------|------Y------|
-----111-------|------C1-------|------N------|
-----112-------|------A2-------|------N------|
-----112-------|------B2-------|------Y------|
-----113-------|------A3-------|------N------|
-----113-------|------B3-------|------N------|
-----113-------|------C3-------|------Y------|
-----113-------|------D3-------|------Y------|
-----113-------|------E3-------|------N------|
I have defined names corresponding to the column headers for each range of data.
My dilemma is to populate cbxSystem, and depending on the user selection, cbxSchool would be populated with the available data for that system. Also, depending on the chosen school, chkTest would be checked if the Test value is Y… There are a few other text fields on the form and, when completed, the user would click a “Submit” button and it would create a calendar entry for the selected date and times.
The data doesn’t need to be in an Excel file, anything will do…
Sure hope that someone can get me on the right track!
Thanks…
Dave