I think I figure it out reading some other post.
I just add the header and footer after I've merged the data.

Now just need some help saving each letter with different person's name as a PDF file.

I found the following code in a different post, which does it by page numbers.

How can I edit it so that it'll check the person's name and then use that as a start of a new page and find the end/last page with my signture on it or page break?
Thank you!!!

Sub Demo()
Dim i As Long, StrNm As String
StrNm = "C:\Monthly\Receipt No -"
With ActiveDocument
For i = 1 To .ComputeStatistics(wdStatisticPages)
.ExportAsFixedFormat OutputFileName:=StrNm & i, ExportFormat:=wdExportFormatPDF, _
From:=i, To:=i, OptimizeFor:=wdExportOptimizeForPrint
Next
End With
End Sub

Lines are a fluid concept in Word and can vary with printer driver. What I'd need to know is whether that line is in the first or second paragraph on the page and whether the lines within those paragraphs (if they're multi-lined) are terminated by line breaks.

As for the use of page breaks, the field code inserts manual page breaks which can be used as the document delimiters, rather than relying on pages, per se, since a long letter might span more than one page.

Since you have header/footer content, some extra code would be required to replicate that in each of the output documents also.

Save as PDF file

Hi All,

I've being reading Graham Mayor site and managed to get my mail merge to print separate document for each letter.

But I still need these document in PDF format and I'm having trouble figuring out which line of code to replace "ExportAsFixedFormat OutputFileName:=sName, ExportFormat:=wdExportFormatPDF," to make it work. I was hoping someone can give me a hand with modifying the code below:

It would have been helpful if you'd indicated what you're using for the document delimiters from the outset, especially given that the title you originally gave the thread refers to a process that doesn't ordinarily use Section breaks... Had I known that, I wouldn't have offered the solution I gave. A process that uses Section breaks is in some respects much easier to implement. However, I'm travelling at the moment and don't really have time to focus on that. You will, however, find some code you can adapt at: http://www.gmayor.com/individual_merge_letters.htm

Hi Paul,
Sorry about the inconvenience, I didn't use this code to start with.
Since I was not able to incorporate printing to PDF in your original mail merge tutorial I went looking for a different solution.
So now I use that for the mail merge and do a 2nd step of changing all the break pages to section breaks so I could run above macro.

Since I was not able to incorporate printing to PDF in your original mail merge tutorial I went looking for a different solution.
So now I use that for the mail merge and do a 2nd step of changing all the break pages to section breaks so I could run above macro.

But if you hadn't changed the page breaks that the tutorial uses to Section breaks, the Sections problem would never have arisen...