BIRTHDAY MESAGES

For users or potential users.
Post Reply
drjorgel1
Posts: 20
Joined: Sat Feb 25, 2012 2:45 am

BIRTHDAY MESAGES

Post by drjorgel1 » Sun Apr 08, 2018 4:06 am

CAN WE SET UP OD TO SEND BIRTHDAY MESSAGES THRUE E-MAIL?

User avatar
Jorgebon
Posts: 502
Joined: Mon Jun 18, 2007 2:25 pm
Location: Mayaguez, PR
Contact:

Re: BIRTHDAY MESAGES

Post by Jorgebon » Mon Apr 09, 2018 5:26 am

You can do postcards, but I don't think you can send it through e-mail. Maybe someone else knows a way.
Jorge Bonilla DMD
Open Dental user since May 2005

rhaber123
Posts: 415
Joined: Fri Dec 11, 2009 12:09 pm

Re: BIRTHDAY MESAGES

Post by rhaber123 » Sat Apr 14, 2018 12:31 pm

We use Mopensoft SMS plugin,
we use it for all of our text messaging services and the bithdays messages
viewtopic.php?f=7&t=6551

In the morning, my receptionist start OD, and go to the SMS birthday option in the plugin , and click on it, and all the patients who has a birthday on that day will receive the preset message that you already have in OD, ( the message that is supposed to be printed on a post card)
you also have the option to pick another date.

So by just few clicks, our patients receive the birthday message as a text message and they love it, it even plays a youtube video
Dear ?FName, Happy Birthday from Dr JOHN DOE and his staff. We celebrate this day with you ! http://www.youtube.com/watch?v=dePMU8R131s

TEXT MESSAGE WORKS BETTER THAN EMAIL.
80% of our patients provided us with their cell number

=========================================================================================================================================
for the other 20%
For Email, it can be done one patient at a time, or use a third party software to send bulk emails.
use this query:
/*397 Active Patients with birthday in current month, with Age, Birthdate, Name, Address, and Email.
Sorted by day of month for birthday.*/
SELECT p.LName, p.FName,(YEAR(CURDATE())-YEAR(Birthdate)) - (RIGHT(CURDATE(),5)<RIGHT(Birthdate,5)) AS 'Age',
p.BirthDate, p.Address, p.Address2, p.City, p.State, p.ZIP,p.Email, p .WirelessPhone
FROM patient p
WHERE p.PatStatus=0 AND MONTH(p.BirthDate)=MONTH(CURDATE())
ORDER BY DAY(BirthDate),p.LName, p.FName;


You can have a preset BIRTHDAY message in the Email templates, and a preset "Belated Birthday message" , and the receptionist will send it to those who do not have a cellphone number.

hrdsq
Posts: 18
Joined: Mon Dec 14, 2015 3:42 pm
Contact:

Re: BIRTHDAY MESAGES

Post by hrdsq » Mon Apr 30, 2018 9:49 am

If you are looking for JUST email greetings. Check out our FREE HTML email package for greetings. You can build your own beautiful emails thru our powerful designer and automatically email greetings to patients on their big day.

http://hrdsq.com/patientxpress
http://www.hrdsq.com
Swiss Army Knife for Open Dental
Image

Post Reply