HELP: MASS SENDING EMAIL/SMS FOR COVID19 OUTBREAK

For talking about and sharing plug-ins that have been developed by outside developers.
Post Reply
euphoria0314
Posts: 1
Joined: Wed Mar 04, 2020 11:58 am

HELP: MASS SENDING EMAIL/SMS FOR COVID19 OUTBREAK

Post by euphoria0314 » Wed Mar 25, 2020 5:14 pm

If I want to send a mass email to all my patients through open dental — is there an easy way to do that?

rhaber123
Posts: 328
Joined: Fri Dec 11, 2009 1:09 pm

Re: HELP: MASS SENDING EMAIL/SMS FOR COVID19 OUTBREAK

Post by rhaber123 » Wed Mar 25, 2020 10:36 pm

We use AB bulk Mailer. Cost $25 , one time only, and no more charges after that.
It extract emails from any list that you export from OD.
It allows you also to design your own newsletters
You can extract the first name of your patient, Last Name, etc... and send personalized emails.

You can run this query to get the email addresses of ALL the active patients, export it into Excel, and import it into AB Bulk Mailer or any other Email marketing service :
SELECT FName, Lname, EMail, Birthdate, WirelessPhone FROM patient WHERE PatStatus=0 ORDER BY LName, FName;

For more information http://opendentalsoft.com/forum/viewt ... 7&t=7191

joes
Posts: 1
Joined: Tue Aug 13, 2019 12:41 pm

Re: HELP: MASS SENDING EMAIL/SMS FOR COVID19 OUTBREAK

Post by joes » Thu Mar 26, 2020 9:52 am

We don't currently have a feature in Open Dental for sending mass emails, You can vote on feature request #728 if you would like us to develop a feature for this. See our manual page, https://www.opendental.com/manual/featurerequests.html, for more details on how feature requests work.

If you use Microsoft Word and Outlook, you can also perform a mail merge to send mass emails. First you would run a query in Open Dental, similar to what rhaber123 suggested. If you only want a list of the information for family guarantors, you can run the following query:

SELECT
g.LName,
g.FName,
g.Email
FROM patient p
LEFT JOIN patient g ON p.Guarantor=g.Guarantor
WHERE p.PatStatus=0
AND g.Email LIKE '%@%'
GROUP BY p.Guarantor
ORDER BY g.LName

You would then export the resulting report as a text file. We have instructions on how to run a mail merge in our manual at: https://www.opendental.com/manual/mailmergeword.html

Post Reply