Link to home
Start Free TrialLog in
Avatar of forsters
forstersFlag for United Kingdom of Great Britain and Northern Ireland

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
Avatar of David Lee
David Lee
Flag of United States of America image

Hi, forsters.

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.  
Avatar of forsters

ASKER

Many thanks. I am only a beginner at code so am not sure where and what to write.  Any pointers?  
ASKER CERTIFIED SOLUTION
Avatar of David Lee
David Lee
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial