Mail Merge a lot at once

gmayor · #2 10-15-2016, 10:46 PM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge fields merge incorrectly and won't fix.	marym	Mail Merge	3	04-09-2016 05:17 AM
Mail Merge is Deleting objects in my header and footer during the merge	bgranzow	Mail Merge	9	06-05-2015 05:03 AM
Is data merge and mail merge the same thing?	ikearns	Mail Merge	1	09-12-2014 03:53 AM
Mail merge how to link mail merge field value to a column heading	dsummers	Mail Merge	1	05-08-2014 02:59 PM
Saving INDV mail merges During the mail merge	sedain121	Mail Merge	2	10-04-2011 07:52 PM