Thanks for the sample document. Unfortunately, this did not resolve my issue. The sample document simply moved the Customer Name into a floating textbox outside the header and footer. I actually need the specific items in the header and footer for my process to work correctly. In the current example, when the number of invoice items exceeds the current page, the items just carry down to the next page, but I lose the header and footer on the second page. This is why I need my merge items inside the header and footer.
Can you send me an example of this working with merge tags in the header and footer, as well as merge the order data into the body of the document?
doc = New Document(“c:\INVOICE.DOCX”)
dt = New DataTable(“InvoiceMaster”)
dt.Columns.Add(“StoreIdent”)
dt.Columns.Add(“InvoiceMaster_CustomerName”)
dt.Rows.Add(1, “ABC Company”)
dt.Rows.Add(2, “ACME Security”)
dt.Rows.Add(3, “CABLE Company”)
dt300Detail = New DataTable(“InvoiceDetail”)
dt300Detail.Columns.Add(“StoreIdent”)
dt300Detail.Columns.Add(“InvoiceDetail_Description”)
dt300Detail.Columns.Add(“InvoiceDetail_Quantity”)
dt300Detail.Columns.Add(“InvoiceDetial_Price”)
dt300Detail.Rows.Add(1, “Deli Meat”, “2”, “12.99”)
dt300Detail.Rows.Add(1, “Chicken Soup”, “1”, “4.79”)
dt300Detail.Rows.Add(1, “Turkey”, “1”, “9.99”)
dt300Detail.Rows.Add(2, “Roast Beef”, “2”, “13.49”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Taco Sandwich”, “1”, “9.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Taco Sandwich”, “1”, “9.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Taco Sandwich”, “1”, “9.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Taco Sandwich”, “1”, “9.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Taco Sandwich”, “1”, “9.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Taco Sandwich”, “1”, “9.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Taco Sandwich”, “1”, “9.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Chicken Taco Sandwich”, “1”, “9.99”)
dt300Detail.Rows.Add(2, “Chicken Breast”, “1”, “3.99”)
dt300Detail.Rows.Add(2, “Pickles”, “1”, “9.99”)
dt300Detail.Rows.Add(3, “Candy Bars”, “5”, “4.98”)
ds.Tables.Add(dt)
ds.Tables.Add(dt300Detail)
ds.Relations.Add(“Ids”, dt.Columns(“StoreIdent”), dt300Detail.Columns(“StoreIdent”), False)
doc.MailMerge.CleanupOptions = MailMerging.MailMergeCleanupOptions.RemoveUnusedFields Or MailMerging.MailMergeCleanupOptions.RemoveUnusedRegions Or MailMerging.MailMergeCleanupOptions.RemoveContainingFields
doc.MailMerge.ExecuteWithRegions(ds)
doc.Save(“C:\INVOICE.PDF”, SaveFormat.Pdf)