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.