Custom form and VBScript

Status
Not open for further replies.

dlr

Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
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
 
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 would have thought this to be a pretty simple script for the script savvy... :confused:
 
Actually, no its not. Or I'm not savvy enough. ;)

I looked for some code samples and could not find any in a quick search - I was going to take a longer look at it when i had time.

Have you tried the msdn forums? The really savvy guys hang out there - http://social.msdn.microsoft.com/Forums/office/en-US/home?forum=outlookdev - and they can tell you if its a simple script and give you some pointers.
 
I posted in the Outlook for Developers forum and a moderator said she was trying to involve some senior engineers. That was a week ago... I guess they didn't get too involved since I haven't heard anything back. :(
 
I'm not sure why they need senior engineers - any of the guys that frequent the group should be able to answer.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
M VbScript for Command Button on Contacts Custom Form Using Outlook 1
G Apply Custom Contacts form to all existing Contacts Outlook VBA and Custom Forms 1
G Add Map It button to Custom Contacts Form in Outlook Outlook VBA and Custom Forms 1
G Outlook 2021 Add Picture to Custom Contact Form Outlook VBA and Custom Forms 2
P Can't add custom field to custom Outlook form, it always adds to the Folder instead Outlook VBA and Custom Forms 2
AndyZ Contact Custom Form Tiny Text Outlook VBA and Custom Forms 3
A How to reduce size of custom contact form? Outlook VBA and Custom Forms 3
Witzker How to get the button Karte ( map) in custom contact form Outlook VBA and Custom Forms 2
B Outlook 2019 Custom Email form - Edit default email form Outlook VBA and Custom Forms 6
J Does the .fdm contain my custom form? How to make ol use it? - ol2007 Outlook VBA and Custom Forms 4
J ol2021 custom form not displaying pics Outlook VBA and Custom Forms 37
cbufacchi Outlook 365 Populate custom Outlook Appoint form Outlook VBA and Custom Forms 2
C Create Meeting With Custom Form Outlook VBA and Custom Forms 2
J custom form not displaying pictures Outlook VBA and Custom Forms 7
I Button PDF in Outlook Contact custom form Outlook VBA and Custom Forms 1
K Font Sizing in Custom Form Regions for Contacts Outlook VBA and Custom Forms 1
K can't get custom form to update multiple contacts using VBA Outlook VBA and Custom Forms 3
H Custom Outlook Contact Form VBA Outlook VBA and Custom Forms 1
F Validation on custom task form after task acceptance Outlook VBA and Custom Forms 1
I Error saving screenshots in a custom form in outlook 2016, outlook 365 - ok in outlook 2013, outlook 2010 Outlook VBA and Custom Forms 5
G Other users can't see P.2 with custom fields in Form Outlook VBA and Custom Forms 0
O Create a custom contact form - questions before messing things up... Outlook VBA and Custom Forms 4
L Custom Form Tutoral? Outlook VBA and Custom Forms 6
D Lost Access to Custom Form Outlook VBA and Custom Forms 4
M vCard does not have user-defined fields from my custom contact form (365) Using Outlook 1
S Outlook Custom Form Scripting only working when clicking on "Run this form" Outlook VBA and Custom Forms 2
Victor_50 Outlook 2013 Custom Contact Form starts with "E-mail 2" Outlook VBA and Custom Forms 2
C Custom Form (seperate layout pages and message reading pane) Outlook VBA and Custom Forms 0
C Reading Pane for Custom Form Outlook VBA and Custom Forms 2
N Custom Form Controls Not Visible To Recipient Outlook VBA and Custom Forms 3
Randy Redekopp How To Merge Contact Info to Email Custom Form Template Using Outlook 2
D Problem with custom form including _DocSiteControl1 Outlook VBA and Custom Forms 0
C Custom Outlook Form - Populate Information from Radio Button / Check Box Using Outlook 0
W Message class changes of a custom form changes to the default form Using Outlook 2
A Possible to hide ribbon with custom appointment form? Outlook VBA and Custom Forms 3
S Custom Form, copy user field data to message body Outlook VBA and Custom Forms 12
Andrew Quirl Custom form to route requests based on input criteria Outlook VBA and Custom Forms 1
D Using a VBA Custom Form to Send Reoccurring Email Upon Task Completion Outlook VBA and Custom Forms 4
W Setting up a custom form Outlook VBA and Custom Forms 2
A Greyed out checkbox in custom form Outlook VBA and Custom Forms 4
Z Outlook Custom Form: Adding Dropdown(Project Code) at the end of subject Outlook VBA and Custom Forms 0
Z Adding dropdown list using custom form Outlook VBA and Custom Forms 7
J autocomplete function in custom form Using Outlook 1
D Custom form with html hyperlink Outlook VBA and Custom Forms 7
D populating listbox on custom form from Access Outlook VBA and Custom Forms 7
D Custom Form Accept and Reject Command buttons Outlook VBA and Custom Forms 2
D create an html table in outlook custom form 2010 using vba in MsAccess Outlook VBA and Custom Forms 7
Potty Ash MS Outlook 2010 custom form - validation or formula to request user to check a checkbox Outlook VBA and Custom Forms 16
J Custom form code doesn't run Outlook VBA and Custom Forms 2
R Custom Contact Form how to update when loaded. Outlook VBA and Custom Forms 6

Similar threads

Back
Top