forsters
asked on
Outlook Form - how do I incorporate a drop-down menu which is linked to XL spreadsheet?
I am designing an Outlook form and I need to include a list of users on a drop-down form. I have a list of all users on an Excel spreadsheet but don't know how to make the drop down look at the Excel spreadsheet and bring in the information from it. :D
ASKER
Many thanks. I am only a beginner at code so am not sure where and what to write. Any pointers?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You'll have to write some code behind the form to accomplish this. Doing this is not a good practice. If the spreadsheet is unavailable for any reason, then the form is going to fail.