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.
Select
Tools
then
Manage Office document template
.
Select
Create Excel Document
.
Choose a
Datasource
.
note
If there's only one Datasource, then
Client details
is shown as the only option.
Enter a name for your template, then select
OK
.
Choose the mail merge fields you want to include in your template, then select
Add
.
Select
OK
.
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, select
Create Office Document
.
The
Mail Merge
wizard opens.
Select
Next
.
Select
Generate a document using a template
, then
Next
.
Choose from the Excel mail merge templates that you've previously created, then select
Next
.
Use the drop-down list to specify a file name for your mail merge spreadsheet, then select
Next
.
note
You 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 the
Save datasource file
checkbox to save the file as a Comma-Separated Values (CSV) file.
Mark the the
Add note to each recipient's contact history
if you want to keep track of which clients have received a letter.
After you have completed this
Mail Merge
wizard, the notes will appear on the
General
tab.
Select
Next
.
Select
Open document for printing
, then
Finish
.
The
Mail Merge
wizard will close and a spreadsheet that contains the clients or contacts' details specified by the template opens.