none
Custom form, Comboboxes and VBScript RRS feed

  • Question

  • 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 schools in 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… I also have it in an Access database.

    Sure hope that someone can get me on the right track!

    Thanks…

    Dave


    • Edited by DLEER Wednesday, June 5, 2013 3:41 PM
    Wednesday, June 5, 2013 3:40 PM

Answers

All replies

  • Hi Dave,

    Thank you for posting in the MSDN Forum.

    I'm trying to involve some senior engineers into this issue and it will take some time. Your patience will be greatly appreciated.

    Sorry for any inconvenience and have a nice day!

    Best regards,


    Quist Zhang [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Friday, June 7, 2013 7:06 AM
    Moderator
  • Hi!

    Thanks for having someone look into this... Any progress?

    Dave

    Monday, June 10, 2013 2:59 PM
  • Is what I'm wanting to do really that difficult to implement?

    Dave

    Friday, June 14, 2013 3:38 PM
  • For lack of any other responses

    If you do a generic google search on the phrase "populate Outlook combo box" - you will find no end of results (vary the search phrase and a whole host of other reference articles become available)

    Some articles as the starting point are as follows:

    How to populate a list box or a combo box control on an custom form in Outlook 2002
    http://support.microsoft.com/kb/290819?wa=wsignin1.0

    To populate a combo box on a Microsoft Outlook form
    http://www.outlookcode.com/d/code/popcombobox.htm

    Connecting Outlook to Databases
    http://www.outlookcode.com/article.aspx?ID=25

    The process in populating a given control has stayed essentially the same through all versions of Outlook when in reference to standard custom forms)

    The above also presumes familiarity with the Outlook Object Model and any other of the object models when invoked from a different office programs (calling/using Excel/Access from within Outlook etc)

    You may also get other responses from

    Microsoft Office Customization and Programming
    http://answers.microsoft.com/en-us/office/forum/customize?page=1&tab=all


    Karl Timmermans [Outlook MVP] "Outlook Contact Import/Export/Data Mgmt" http://www.contactgenie.com


    Monday, June 17, 2013 8:29 AM
  • Thanks for the links Karl...

    I had already gone through those pages and attempted to get something scripted but, as I mentioned in my 1st post, I'm really not proficient in VBScripting. Believe me, I've tried to get something to work but without any success.

    It would be great if someone could at least give me an example, or even better, something adapted to my specific situation!

    Thanks

    Dave

    Friday, June 21, 2013 2:36 PM
  • Given that the links already provide examples for different scenarios applicable to your case, your best bet is probably to contract out the development of your project otherwise you're likely to expend a great deal of time in the process. Your issue isn't just populating the control itself but the data access involved to your external source so you would need to become familiar with either the Excel Object Model or retrieving data from Access in addition to basic functionality of the Outlook Object Model etc etc etc. No one is going to provide code specific to an overall app.

    Generally the types of answers you'll get here (or in any of the programming related forums) are in response to questions like: 

    "Am trying to accomplish "x" but am encountering error "y" - the sample code being used that is generating the error is as follows........................."


    Karl Timmermans [Outlook MVP] "Outlook Contact Import/Export/Data Mgmt" http://www.contactgenie.com

    Friday, June 21, 2013 3:04 PM