Birthday E-mails Mail Merge

[Hersheydmd]

I put together some slides showing how I send birthday e-mails from OD using MS Word and Outlook mail merge.
Hope someone finds it useful.

Click the link to open:
https://docs.google.com/viewer?a=v&pid= ... y=CK7fi_IN

[Hersheydmd]

I modified the Birthday Query to include non-patient and inactive patients, in case I want to send a birthday wish to someone who is not yet or no longer a patient. The list is sorted by PatStatus as well as Birth Day, with all the active patients listed first.

/BIRTHDAY REPORT BY MONTH. CHANGE THE DATES./
SELECT LName,FName,Preferred,PatStatus,Email,Birthdate
FROM patient
WHERE SUBSTRING(Birthdate,6,5) >= '11-01'
AND SUBSTRING(Birthdate,6,5) <= '11-30'
AND PatStatus<3
ORDER BY PatStatus, SUBSTRING(Birthdate,6,5)