How to create a Word directory using 4TOPS Mail Merge
This example shows how to create a mail merge directory template and process using the 4TOPS Mail Merge for Microsoft Access tools. Here we demonstrate the steps for making a telephone directory.
- Use the mail merge wizard to set up the process - no programming required
- Use the Template Designer to drag & drop the fields on your template
- Start using the mail merge process you created
Use the mail merge wizard to set up the process
You always need to have the database open with the form or datasheet you want to use the information from. (You should have already installed the Mail Merge Addin. If not see Installation and activation.)
1.1 Open the data source (table, query or form)
1.2 Start the Mail Merge wizard
1.2a Select the Mail Merge Ribbon
1.2.b Press the Word Mail Merge button
1.3.1 Select 'Word Directory'. (Mail Merge > New > Directory. )
1.3.2 Give a name to the process. Here: Phonelist
1.3.3 Press Next >.
2.1.1 In 'Give template filename' a proposal for the template name is given. We accept the default.
2.1.2 In 'Based on' you can browse to an already existing template. We do - we already have a sort of directory.
2.1.3 Pressing the 'Create'-button opens the Template Designer. On the left the possible fields, on the right some of the fields put in place. (drag and drop )
2.2 Close the Template Designer (save changes)
2.3 On the wizard, skip the following screens, don't check automatic file naming or logging.
2.3.1 Press 'OK'
The template and mail merge process have been created.
In the case of phone list the records has to be ordered alphabetical. Do this in the database.
3.1. Press 'Run' and evaluate the result with the selected data. OR
Press 'Open the Mail Merge Selection dialog' on the What's next dialog. The next time you will be using the 'Existing' button on the Mail Merge ribbon (Access 2003: menu Mail Merge > Open...).
3.2. Press 'Run' to create the document with all records
You see Page Breaks after each record. This is a property of the Mail merge process you can (de)select in the Procesdesigner.
Not quite satisfied? Further editing on the template is possible via Existing > "template name"> Edit. (MailMerge > Open > Edit.)