BIRTHDAY MESAGES
BIRTHDAY MESAGES
CAN WE SET UP OD TO SEND BIRTHDAY MESSAGES THRUE E-MAIL?
Re: BIRTHDAY MESAGES
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
Open Dental user since May 2005
Re: BIRTHDAY MESAGES
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.
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.
Re: BIRTHDAY MESAGES
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://hrdsq.com/patientxpress