The Individual Merge Letters add-in is by far the most downloaded add-in from this site with many thousands of users world wide. However feedback, while helpful in developing the add-in, has revealed a fatal flaw when presented with CSV data sources.
Thanks probably to Microsoft's interminable updates, it has been found that the process now fails when presented with merge documents using CSV data sources. Why this should occur I have not yet been able to establish, so I have recommended the use of Excel data sources, which do not exhibit this limitation.
Unfortunately CSV data sources have been used as a means of overcoming the 256 field limit for mail merge and while admittedly few users have suffered from this limitation, I felt that I should address it. The solution is the add-in featured on this page.
I should point out that while there were some formatting issues with the original Individual Merge Letters add-in, this has now been fixed, however where any formatting anomalies remain, where Excel data sources are used, the Many to One add-in, used in One to One mode will split the document without affecting the original formatting, as it does not use mail merge to complete the process and may be considered as an alternative.
The Many to One add-in adds another layer of merge options, should you wish to create a many to one merge or a merge directly to e-mail.
The add-in is a template which should be installed in the
Word startup folder. The zip file includes a self extracting
installer or you can manually save the template into the
required folder - If you have not changed the preferred startup
folder it can be located (in English language versions of
Windows) by typing
in the Windows Explorer Address bar and pressing Enter.
When Word is next started an additional group will be added to the Mailings Tab:
The reset button is provided to clear the program settings which are stored as variables in the template itself. The other button runs the program.
The application is error trapped to ensure that it can only operate on a merge document with an attached data source, If use is attempted otherwise you will see a warning message.
When run for the first time, following a standard disclaimer message you will see the following dialog with the available fields from the current merge document displayed. You may select any item from the list to be used as the filename. Ideally you would use a filename that is unique to each record, though the application will not overwrite existing filenames where two records share the same data. Instead a number is added to the filename.
As the add-in only works with merge documents, there will always be fields from that document presented in the list when the add-in is run. The first time the add-in is run (and at any time when a selected folder to store the documents is no longer available) the folder path text box will be empty and coloured pink.
If the folder path is typed into the dialog and that path doesn't exist, the background colour will remain pink and the 'Split to Documents' action button will be disabled. A folder selected with the browse function will always be valid, so the background colour will change to green,
The 'Split to Documents' action button will be enabled when the name field is selected.
The add-in provides for a second field to be included in the filenames of the individual documents. This second field is always inserted after the first selected field data, and you may choose from a small selection of separator characters.
The add-in by default creates PDF format files using Word's built-in PDF converter, however for users who have PDF Creator installed, the add-in will detect this and offer the option to create PDF files using PDF Creator, with the additional option of creating those PDF files with a selection of security options which are presented when you leave the main dialog and the relevant option is selected (see second and third illustrations below).
The add-in adds a temporary field (or fields if a second field is chosen to name the document) to the start (or optionally the end) of the merge document.
As the merge is completed the added field(s) are removed from the merge document before saving.
All that remains is to ensure that all the personal options are set and click the button to split the document.
The merge starts by creating a new merge document. In some circumstances e.g. in non-English version of Word, and where there may be more than one unnamed document present, the process may not be able to identify which is the merge document. When that happens you will see the following dialog which will list the unnamed documents. Select the merged document and click 'Continue' which will become available when a selection has been made. Cancel will cancel the entire process.
A progress indicator will display as the merge runs.
This is a companion add-in to the Individual Merge Letters add-in, to produce individual merge letters in pdf and document formats; and is especially useful with merge documents and CSV data sources with large numbers of fields.