The basics of filling a list on a custom form are covered at http://www.outlookcode.com/d/formcontrols.htm#listcombo . Getting data from Excel is a simple matter of opening the worksheet and iterating the right rows; some of the import samples at http://www.outlookcode.com/d/customimport.htm should give you those basics.

Retrieving data from SharePoint is something I don't have a good VBScript sample for, but I'm sure Google can turn up one for you.

BTW, Microsoft InfoPath does a lot of this out of the box and is definitely the future of intra-organization forms.

--
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

"DougD" wrote in message ...
Can you provide any guidance on how to do this or references/examples I can
use to get me started?
--
DougD


"Sue Mosher [MVP-Outlook]" wrote:

Yes, by writing code behind a custom form or in an Outlook add-in to read the information from the data source and use it to populate a list or combo box that offers choices. The user would, of course, have to be able to connect to the data source.

"DougD" wrote in message ...
Is there any way to create a lookup field within Outlook that uses for its
content an Excel spreadsheat or SharePoint list? I have a SharePoint list
that contains a "Client Account Field" to which many of the contacts within
Outlook are associated.

It would be much easier for the user to have lookup field from which they
can select the proper Client Account. This could be built as a choice field
but that would have to be updated each time a new client account is added or
amended. A link would be a much better solution if that is possible.
--
DougD