#1
|
|||
|
|||
Mail Merge a lot at once
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! |
#2
|
||||
|
||||
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.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
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 |