Hi guys,
I'm currently working on a Mail Merge Project and at present, the letters are built using a VBA front end in Excel, exported to word then saved via a VBA script as individual files with the type of letterhead, client name and reference number forming the filename i.e:
FormalLetterhead Smith 12345.docx
FormalLetterhead Jones 45678.docx
BusinessLetterhead Ali 78910.docx
SalesLetterhead Barry 101112.docx
However, the merge has now reached the point whereby the area printing them has asked that these individual documents are grouped into single documents by letterhead, i.e, one document containing all of the FormalLetterhead letters, one containing all of the BusinessLetterhead letters etc.
I've experimented with the 'insert' options but this appears to throw out the formatting of the letters which are all of variable length, potentially causing issues with the printing.
HAs anyone explored VBA scripting for merging multiple docs into one based on filename?
I won't be able to use any plugins or third party addons for this has anyone got any ideas?
Bookmarks