Creating Interest Lists Using Dentrix Mail Merge Feature

The Dentrix Mail Merge feature allows you to generate lists of patients who meet specific criteria. Those lists can be easily imported into YAPI as Interest Lists to be used in your e-mail campaigns.

In this article, we will show how to export the list of patients with remaining insurance benefits from Dentrix, import it into YAPI, and create end-of-year Use It or Lose It e-mail campaign.

Export Data from Dentrix

Open Dentrix Office Manager, click on Letters and select Misc in Letters

one.png

Click New button

two.png

In Patient Report View window enter Letter Name Merge and Data File Name, enter temp in Merge Letter Template, and select Patient box in Status

three.png

On Patient Filters tab select Dental Ins. and enter Remaining Benefits range; check Prim. Ins. and Sec. Ins.

four.png

Then select Appointments, enter Date Range, select Existing Patients with No appointments in date range.

five.png

Switch to Data Fields tab and check Last Name and First Name data fields. No other data fields should be selected.

six.png

Click the Ok button to close Patient Report View.

Select newly created letter, and click Create/Merge button. Select Create Data File ONLY, and click Ok button

seven.png

Wait until the list is created.

eight.png

Import list into YAPI

Click Setup toolbar button, and select Manage Interest List.

nine.png

Click the New button, then enter list name and check Import from file box.

ten.png

On the Import Interest List window click Browse button, navigate to a folder that contains data file created by Dentrix (typically in Dentrix’s DocFiles\EXPORTS folder ), select data file.

Select Tab as Separator and click Load button.

eleven.png

YAPI loads data and shows the number of records processed. Select FName and LName, select yourself from provider list, and enter list details. Click the Process button.

YAPI may show you a warning message. Click Yes to continue.

twelve.png

It may take several minutes to finish processing.

thirteen.png

Sending emails

First, you need to create an email template for your campaign. Go to Manage Documents and Templates to create a new template.

fourteen.png

Click here to download the above template. Do not unzip, save on your local hard drive. To install, just follow instructions.

Go to Search Patient:

fifteen.png

Go to Interest List tab and select interest list. Click the Search button. Once patients’ list is loaded click With email box to select patients with email.

sixteen.png

To initiate an email, click the Email button.

Enter Subject and select email template from the list. Click Send.

seventeen.png

Note that you can mail a postcard to all patients that don’t have email: select Without email box and click the Print button.

Was this article helpful?
1 out of 1 found this helpful