Outlook Form List box data source

[pmt82]

Hello,

I have created a custom outlook form that will be used for emailing
internaley. I created a field which is a drop down box where I would like to
attach a data source of either an excel document or access table. These need
to be kept up-to-date with the latest client job numbers. Because I haven't
got much experience in this field I would greatley appreciate any help as to
how to code in an external source so that all a user needs to do is select
the drop down box, select the job number and away they go from there.

Cheers

 

[Sue Mosher [MVP-Outlook]]

Is the document or database located in a shared network file folder? The sample at http://www.outlookcode.com/codedetail.aspx?id=788 will give you a good example of working with data in a group of Excel rows. Also see http://www.outlookcode.com/article.aspx?ID=32 for information on the AddItem and List approaches to filling combo box rows.

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

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