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 Customer Order Update document that requires a WORD MACRO to realise his formatting once the Merge has taken place. I have created a MACRO in the WORD document that is able to perform the correct formatting on the WORD document after the merge with EXCEL spreasheet data has taken place. However, with a multiple page document I find that the MACRO is only applied to the 1st page of the document Subsequent pages of the generated .pdf do NOT have the MACRO applied ( I have various detail lines that are hash preceded capital letters that trigger the MACRO to perform a subtitle substitution ) As the MACRO goes through 25 lines of detail (below the fixed document header) in a Loop to perform substitutions I wondered if expanding the Loop to 50 lines would allow the second page of the document to also receive the MACRO processing. This did NOT happen Please advise how I can get the MACRO to apply to every page of the mail merged document I do not believe that the MACRO can only be applied once to the 1st page of the mail mereged document only regards