Hi
I have an Excel 2003 spreadsheet with approx 100 company names and their address. I want to setup a Word 2003 document where the user can click on a drop down arrow to a field called Company and they will see the company names in the Excel spreadsheet.
Secondly, when they select a company from the drop-down list, the address details for that company will appear in the Word document(s) where merge fields have been added?
Can someone enlighten me as to what they think is the best approach or direct me towards a tutorial or guide?
Thanks in advance.
Kenneth
I have an Excel 2003 spreadsheet with approx 100 company names and their address. I want to setup a Word 2003 document where the user can click on a drop down arrow to a field called Company and they will see the company names in the Excel spreadsheet.
Secondly, when they select a company from the drop-down list, the address details for that company will appear in the Word document(s) where merge fields have been added?
Can someone enlighten me as to what they think is the best approach or direct me towards a tutorial or guide?
Thanks in advance.
Kenneth