Hello Sir,

I am basically using mail merge via input info from an excel file. I am using the IF function to display the info of the contents that are selected in the excel file (i.e. each content is a different page and is separated via section breaks).

Then I use a macro to export the mail merge to letters. The final form is the attached file.
OPTION 1
You have provided a macro to delete all headings so I am left with the final text to print. What I am trying to achieve (best case scenario) is to have a code to delete the pages that contain only ¶ and section breaks (i.e. pages that do not contain any text).

OPTION 2
Go to each page, select between headings and print the required page.

Option 1 would be ideal but I have seen that it is not easy to achieve. Please advise.

Thank you for your time.

Attached Files

FINALISING AUDIT CHECKLIST DOCUMENT.docx (21.9 KB, 7 views)