Linking dropdown values

[Wiggins]

Is there an easy way to create a list of values in excel and then link to
this list in the dropdown box "Possible Values" in an Outlook form? I have
one dropdown box that will have many values and may change from time to time
so I don't want to have to type them in with a colon every time, especially
while I am developing the form for the first time.

 

[Ken Slovak - [MVP - Outlook]]

Using possible values would one-off the form if you do that on the fly at
runtime. Check at www.outlookcode.com and search on "possible values" for
possible problems.

I'd use code to access the Excel data and then just fill the dropdown list
with those values, also using code, in the Item_Open() event handler.