Bulk e-mails

[Hersheydmd]

For the past several Mondays we've been sending out birthday e-mails for the week. We get the list from the Birthday Report and then manually send each one. Has anyone figured out a way to bulk send e-mails to all at once, personalized with their names in it?
Likewise, how would you send out a mass e-mail (eg. newsletter) to all your patients?

[jrpappy]

Have you ever considered Constant Contact or a similar service for newsletters? We export a list of preferred names and email addresses and send via Constant Contact.

We are also going to start using their Customer Survey to get feedback from patients who have been in recently. Constant contact is really cheap compared to a lot of other marketing strategies.

[Hersheydmd]

I've considered it, but I'm sure there is a way to do it in-house.
There must be a way to export a list of e-mails that meet a certain criteria, and then mail merge them into Outlook or something like that. If anyone is doing this already, please share your knowledge.

[rhaber123]

I use Group Mail Pro for Bulk email.
I bought it few years ago.
They offer Group Mail 5 a free version, but it is limited to 100 emails.

Group Mail Pro, can send PERSONALIZED messages,
it can extract any information needed from a document, and organize it to send the personalized messages.

I am trying to write my first QUERY:
This query will show,
1-Recall date due for a certain period of time,
2-the emails of the patients,
3-and the appointment date and time if the patient already had an appointment.

The query below that I assembled from previous queries, does not show the recall for procedures D1110, and D4910, (prophy and perio maintenance)
It shows for all recalls that are due
(I set my recall to track also bitewings , FMX, and Scaling and root planing)


Any assistance
1-to show only the recall for procedures D1110, and D4910
2-and the the appointment date and time if the patient already had an appointment

will be appreciated, Thank you

Below is what I have found:

/*Emails, recall info, appointment time and date, for patients with a specific date range, with date of last visit*/
/*Change dates AS needed in first line of query*/

SET @StartDate='2011-04-01' , @EndDate='2011-04-30';
SELECT p.LName, p.FName, p.BirthDate, p.Email, r.DateDue, d.ItemName AS 'RecallStatus'
FROM patient p
INNER JOIN recall r ON p.PatNum=r.PatNum
LEFT JOIN definition d ON r.RecallStatus=d.DefNum
WHERE (DateDue BETWEEN @StartDate AND @EndDate)
ORDER BY p.LName, p.FName;