BIRTHDAY MESAGES

For users or potential users.

BIRTHDAY MESAGES

Postby drjorgel1 » Sun Apr 08, 2018 4:06 am

CAN WE SET UP OD TO SEND BIRTHDAY MESSAGES THRUE E-MAIL?
drjorgel1
 
Posts: 17
Joined: Sat Feb 25, 2012 3:45 am

Re: BIRTHDAY MESAGES

Postby 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
User avatar
Jorgebon
 
Posts: 492
Joined: Mon Jun 18, 2007 2:25 pm
Location: Mayaguez, PR

Re: BIRTHDAY MESAGES

Postby 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.
rhaber123
 
Posts: 296
Joined: Fri Dec 11, 2009 1:09 pm

Re: BIRTHDAY MESAGES

Postby 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
hrdsq
 
Posts: 17
Joined: Mon Dec 14, 2015 4:42 pm


Return to Main Forum

Who is online

Users browsing this forum: Google [Bot] and 12 guests

cron