How to populate values in drop down list

[Marin]

Hi all,

How can I programatically populate/modify values in drop
down list in Outlook form?

Thanx in advance, Marin

 

[Sue Mosher [MVP-Outlook]]

In one of the built-in lists? Yoiu can't. In a list you create yourself? Use
code in the Item_Open event and the standard combo box method and
prooperties -- ListAdd, List or Column. See
http://www.outlookcode.com/d/formcontrols.htm#listcombo

 

[Marin]

Thank you Sue,

Obviously, I wasn't clear enough, I need to populate combo box values from
the VB application, not from VBA in Outlook form. I have the application that
populates Outlook form from SQL database, send them to users and then reads
and loads message data back to SQL. The problem is possible values in combo
box; they should be populated from database.

Please advice.

Regards, Marin

 

[Marin]

Thank you Sue,

Obviously, I wasn't clear enough, I need to populate combo box values from
the VB application, not from VBA in Outlook form. I have the application that
populates Outlook form from SQL database, send them to users and then reads
and loads message data back to SQL. The problem is possible values in combo
box; they should be populated from database.

Please advice.

Regards, Marin

 

[Marin]

Thank you Sue,

Obviously, I wasn't clear enough, I need to populate combo box values from
the VB application, not from VBA in Outlook form. I have the application that
populates Outlook form from SQL database, send them to users and then reads
and loads message data back to SQL. The problem is possible values in combo
box; they should be populated from database.

Please advice.

Regards, Marin

 

[Marin]

Thank you Sue,

Obviously, I wasn't clear enough, I need to populate combo box values from
the VB application, not from VBA in Outlook form. I have the application that
populates Outlook form from SQL database, send them to users and then reads
and loads message data back to SQL. The problem is possible values in combo
box; they should be populated from database.

Please advice.

Regards, Marin

 

[Sue Mosher [MVP-Outlook]]

Same method. You can use the Inspectors.NewInspector event to monitor for
items opening, test the MessageClass, and if it's your custom form, populate
the control values.


(Outlook form code is VBScript, not VBA, BTW.)

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers