Mail Merge a lot at once

[bbrennan]

Hello Friends, my boss wants me to do 19 mail merges of a single document. 19 different spreadsheets, all that need to be merged into the same document. The spreadsheets are already created, and combining them all into one would take as much time as just merging them each individually. Is there any way to do this in one fell swoop? One action that would merge all 19 spreadsheets and create all 19 separate documents? Wow, I think I am asking if it is possible to mail merge a mail merge!

[gmayor]

Essentially mail merge requires a single data source.

You may be able to combine the required values from the 19 sheets into a single sheet that can be used as such a data source, but as we know nothing about the document or the worksheets, only you can determine whether it would be more work to merge the worksheets or separately merge the document; or adopt a different approach. Note that you cannot do multiple merges into the same merge document.

Certainly it would be a lot of work for someone to create a custom application that extracted the appropriate bits of data from each of the sheets and write it to the relevant parts of the document, but not impossible. I doubt that you will find anyone prepared to do that for free.