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.
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 Give a name to the process. Here: Phonelist
1.3.2 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 'Finish'
The template and mail merge process have been created.
Press 'Run' and evaluate the result with the selected data. OR Press 'Open the Process Selection dialog' on the What's next dialog. For now Press ' I'm finished.'
In the case of phone list the records has to be ordered alphabetical. Do this first in the datasource.
3.1.Now use the 'Existing' button on the Mail Merge ribbon (Access 2003: menu Mail Merge > Open...).
3.2. Press 'Run' to create the document with all recordss
You see Page Breaks after each record. This is a property of the Mail merge process you can (de)select in the Process Designer.
Not quite satisfied? Further editing on the template is possible via Designers >Template Designer > "template name". (MailMerge > Open > Edit.)