Link to home
Start Free TrialLog in
Avatar of PLA_LTM
PLA_LTM

asked on

Populate a combo box using a CSV in Word

Hello all

I have a Mail Merge main document which is looking at a CSV file as the source file.  This CSV file may have hundreds of records.  There is a column in this CSV file that contains US States.  At any given time a user will only need to merge info for one or 2 States at a time.  The way the CSV file is produced there may be many records and all the needed information is scattered through out the source file.  

Currently the user clicks on the Mail Merge Recipients button, sorts by States, and selects only the records needed.  This worked well at one time but now it's proving to be very time consuming.

I am looking for a way to provide the user with a Drop Down list that is "linked" to this States column.  So that each time the Main Document is open it will refresh and only the available states will be presented to the user.

Once selected and when the user clicks merge, only the records matching the selected criteria should be merged.

Any help would be appreciated.

Thank you in advance.
ASKER CERTIFIED SOLUTION
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland 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
Avatar of PLA_LTM
PLA_LTM

ASKER

This is Great, exactly what I'm looking for!!