How do you create dropdowns in a form using Microsoft Outlook?

[Mel]

I've tried creating forms and want to lock down the specific selections from
my team. I figured the dropdown would be my best bet. But I can't get
beyond one selection to put into the box.

 

[Hollis D. Paul]

I've tried creating forms and want to lock down the specific selections from
my team. I figured the dropdown would be my best bet. But I can't get
beyond one selection to put into the box.

If you go into the properties of the listbox, you can type in initial values,
which will then show when they drop the list down. You can also initialize the
listbox.List() property to an array that you have constructed, and they will
show in the form.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Mukilteo, WA USA

 

[Sue Mosher [MVP-Outlook]]

Use the AddItem or (better yet) List method to populate the combo box. See http://www.outlookcode.com/d/formcontrols.htm#listcombo

 

[Slappy]

Sue,

Sorry...I'm wondering if you could give me a quick click by click
description...I want to create a list of clients (stored either within
Outlook or somewhere else like Access) which will come up in my list box. Do
I go -> right click on list box - properties - values - choose field? (and
if so where from there)? (I appreciate any answer...you seem busy!)

Slappy

 

[Sue Mosher [MVP-Outlook]]

Choose Field allows you to bind a control on your form to an Outlook property, so that the data the user enters is stored in the item when it's saved. It doesn't have a lot to do with populating a list box, unless you want a static list that doesn't change. That doesn't sound like what you want, but you really haven't sketched out enough of your scenario for me to make concrete suggestions. Did you look at the custom form sample on the page I suggested? Maybe that will give you some context to describe what you want.

Other key issues are what type of form (message, contact, etc.), whether you're using Exchange as your mail server, where you plan to publish the form, etc.
--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

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

 

[Slappy]

Sue,

Thanks for the reply. I run a small law practise. Essentially I want a way
to create notes that are capable of being assigned to different clients (the
notes would be linked to an Access database where they can be better analyzed
and stored). The list box should show an ever changing list of current
clients. I tried to modify the template for Business Notes but that doesn't
seem to be working. I then tried to modify a Journal Entry Form. Can you
offer any suggestions or assistance?

Slappy

 

[Sue Mosher [MVP-Outlook]]

Do you mean notes as in email messages? Notes as in journal entries?

"template for Business Notes"? Are you talking about Business Contact Manager?

Where would the list of clients come from? An external database? If so, then you'll need to write ADO code behind the form to do the lookup; see http://www.outlookcode.com/d/database.htm That page also has tools for exposing an existing database in Outlook.

"notes linked to an Access database"? Are you thinking of storing information from the notes in the database? Using the built-in linking to OUtlook that Access has?

These are also key issues still:

As you're probably catching on, what you're describing is not a simple step-by-step operation.

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

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

 

[Slappy]

Thanks...yes I intend to store the information from the notes in the external
database. I'll look into learning more about ADO code. If I write back I'll
try to have more precise terminology. Thanks for pointing me in the right
direction.