Forum Discussion
Using Mail Merge with MACROS
Hello, I am currently trying to use Mail Merge from EXCEL with a WORD document to be emailed in OUTLOOK The emailed document takes the form of a .pdf attachment Our designer has created a Cus...
It sounds like the macro is only processing a fixed range instead of the entire merged document. Rather than looping through a set number of lines, update the macro to loop through all paragraphs or the full document after the mail merge is complete. Then generate the PDF only after the formatting has finished. That way, every page should receive the same formatting.