View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob Rob is offline
external usenet poster
 
Posts: 14
Default Mail Merging: From Filtered data to Word

I'm not sure if this is an excel issue, but I'll ask here first.

Is it possible to have MSWord mailmerge from excel in the following manner.

I have about 11,000 rows of data and want to mailmerge according to various
criteria. I would like to filter that data (in place) and mail merge, then
filter again with different criteria and mailmerge again, and so on (about
30 times). I'd prefer not to export the filtered data to 30 different sheets
or workbooks.

Is there something special I need to do to make this happen so that Word
only picks up the filtered data?
I know Word has the capability to Filter within the Mail merge process, but
there is too much criteria to change for each of the 30 or more print runs.

Rob