Export client or contact details from Practice Management to create a mail merge document
You can set up Excel templates in Practice Management to export details to mail merge documents.
- Follow steps 1 to 6 to if you have not yet set up an Excel template in Practice Management.
- SelectToolsthenManage Office document template.
- SelectCreate Excel Document.
- Choose aDatasource.noteIf there's only one Datasource, thenClient detailsis shown as the only option.
- Enter a name for your template, then selectOK.
- Choose the mail merge fields you want to include in your template, then selectAdd.
- SelectOK.
- Follow steps 7 to 16 to use an Excel template to export clients' details to a mail merge document.
- From a list of Clients or Contacts in Practice Management, selectCreate Office Document.TheMail Mergewizard opens.
- SelectNext.
- SelectGenerate a document using a template, thenNext.
- Choose from the Excel mail merge templates that you've previously created, then selectNext.
- Use the drop-down list to specify a file name for your mail merge spreadsheet, then selectNext.noteYou can also enter text to make a custom filename. Any standard characters valid for filenames are allowed. Invalid characters include: \, /, :, *, ?, ", <, >, and |.
- Choose from the additional options as needed.
- Mark theSave datasource filecheckbox to save the file as a Comma-Separated Values (CSV) file.
- Mark the theAdd note to each recipient's contact historyif you want to keep track of which clients have received a letter.After you have completed thisMail Mergewizard, the notes will appear on theGeneraltab.
- SelectNext.
- SelectOpen document for printing, thenFinish.TheMail Mergewizard will close and a spreadsheet that contains the clients or contacts' details specified by the template opens.