Long list dropdown box
 

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

Long list dropdown box
 

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
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Josh Oeltjen" wrote in message ...
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

Long list dropdown box
 

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]" wrote:

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
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Josh Oeltjen" wrote in message ...
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

Long list dropdown box
 

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
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Josh Oeltjen" wrote in message ...
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]" wrote:

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

"Josh Oeltjen" wrote in message ...
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