Mail merge with filter using data inputted by user
Hi,
I'm quite a novice when it comes to mail merge. I have a document set up (word 2003) that gets it's data using mail merge from an Excel spreadsheet.
The data required is determined by a 'date' field and a 'shift' field.
At present I can manually go to mailings/edit list/filter and set the required date and shift values. This works fine, but different people are going to be using this on a daily basis, so I would like to have a text box for 'date' and 'shift' in the main word document which the user can enter, and the filter will then run on these values. Explaining to each user how to edit the values in mailings/edit list/filter will no doubt cause problems.
Is this possible? Would appreciate some advice on how to set this up.
|