Long list dropdown box

[Josh Oeltjen]

I have a list of around 200 entries that i would like to include in as a
dropdown list in an Outlook form. Is there anyway to create a list this long?

thanks

 

[Sue Mosher [MVP-Outlook]]

The easiest way is to fill an array and then set the control's List property to that array. See http://www.outlookcode.com/d/formcontrols.htm#listcombo

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Josh Oeltjen]

Sue-
I'm not real familiar with programming. I understand that this code takes
an array and creates a lists out of it but where do i insert this code? and
where do i store my list?

thanks

 

[Sue Mosher [MVP-Outlook]]

You can store your list wherever is appropriate for your application scenario (which you know a lot more about than we do). These are all possibilities:

1) In a property in the Outlook item
2) In the both of a separate Outlook item or a CDO hidden message
3) In a text file
4) In a database

How you access the data in the list depends, of course, on where you store it.

Any code to initialize controls goes in the Item_Open event handler for the form. Did you look at the code behind the sample form on the page I suggested?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers