I have created a template in MS Word which I use to Mail Merge with the data that I have in Excel
column A in the excel consists the names of the people to which the document is addressed which populates in the word document as "NAME: MR. HARRY POTTER"
Since all the recipients are in 1 mail merged document I have to individually save a document per recipient.
Is there any VBA code that can help me split the document with the help of a delimiter (a special character which will be at the end of every individual recipients document) and then save it with the data that consists in the Column A of the Excel Spreadsheet or from the document itself i.e. "NAME: MR. HARRY POTTER".
Bookmarks