Instead of trying to reinvent the wheel, you might explore some of the solutions that have already been created.



For example, you could use a DATABASE field in a normal ‘letter’ mailmerge main document and a macro to drive the process. An outline of this approach can be found at: http://answers.microsoft.com/en-us/o...1-1996c14dca5d
Conversely, if your workbook has a separate sheet with just a single instance of each of the grouping criteria, a DATABASE field in a normal ‘letter’ mailmerge main document could be used without the need for a macro. An outline of this approach can be found at: https://answers.microsoft.com/en-us/...f-8642e46fa103
For a working example, see: https://www.msofficeforums.com/mail-...-multiple.html

Alternatively, you may want to try one of the Many-to-One Mail Merge add-ins, from:
Graham Mayor at http://www.gmayor.com/ManyToOne.htm; or
Doug Robbins at http://bit.ly/1hduSCB

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks for the response. I got lost with the whole DATABASE thing.

I'm trying Graham Mayor's many to one add in, but I can't get it to work properly.

At first I got Error '4198' Command Failed. I searched and I found out it might have something to do with my Acer Add In, so I disabled that via Options -> Add ins.

That kinda worked as now 5 or 6 letters are being saved, but then the same errors pop up again. Also, those letters are just individual pages, so a letter that's supposed to be 4 or 5 pages long, gets split into multiple individual files.

I also preferred that ability of naming each letter via:

docName = "Letter of renewal - Owner: " & .DataFields("Contact1").Value & ".pdf"

Because this Add In, only allows me to name the letters with a DataField, without adding any other info.