View Single Post
 
Old 06-21-2021, 07:22 AM
shistris03 shistris03 is offline Windows 10 Office 2019
Novice
 
Join Date: Jun 2021
Posts: 7
shistris03 is on a distinguished road
Default

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
File Type: docx FINALISING AUDIT CHECKLIST DOCUMENT.docx (21.9 KB, 7 views)
Reply With Quote