Automate the Creation of Multiple Merge Documents

[langley111]

I have automated a mail merge process using Access VBA, windows scheduler, and the office document object model. This was easy enough. I am attempting to create multiple merged documents based on a field value in the data source. I need to combine several individual merged documents into their own merged document. In essence, I want to automate the Finish & Merge-->Edit Individual Document process. I need a separate merged document for each unique value in a particular data source field--supervisor. I can obviously do this if I hit the datasource several times by altering my select criteria in the .opendatasource method, but I am trying to keep the app from being chatty.