Email Merge Multiple Records
I have a database of patients, many of which have the same physician. I would like to email all of the physicians (one email per physician) a list of their patients.
Can I do this without creating a seperate physician table? I know that I could view all of the related patients in a portal if I did this, but a portal cannot be incorporated into an email script.
Any suggestions would be great!