View Single Post
 
Old 05-13-2022, 03:41 AM
Mattc1978 Mattc1978 is offline Windows 10 Office 2019
Novice
 
Join Date: May 2021
Posts: 13
Mattc1978 is on a distinguished road
Default

Hi Paul,

When the template is populated and a document is created, the document is a doc.x, I have to save as a doc. to remove the active fields. The hangover from the active fields is the brackets, speech marks, *, etc. The macro I hope will remove all of these leaving only the inputs text-wise from the eform. When the eform populates with the text it defaults to a font that can't be used for neurodiversity reasons (dyslexia) and corporate continuity. So I have to manually change to Arial using CTRL A then change to Arial. The form is the quality assured and then posted as a PDF on a tablet, for firefighters to be read as a descriptor of a premises hazards, should they attend a fire there.
If you know of a way to bulk remove empty rows and columns that haven't had input from the eform without using Kutools plus, then that would be amazing. The final bit is to remove anywhere with the word info: if there was nothing pulled through from the eform to populate that row and in turn now being blank delete said row. Many Thanks Matt
Reply With Quote