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.