Notifications
Clear all
Topic starter
Does anyone have a report that will populate all patients over the age of 65 with their address? We are wanting to send a letter out to those patients and would like to be able to use the report with Mail Merge to create mailing labels. When I run an Inquiry for these patients and export to Excel I am not finding a way to break all of the necessary info into individual columns so that it will work with Mail Merge.
Posted : February 10, 2017 3:41 am
If you have access to Crystal, this is a very simple process. Contact me directly if you wish to see an approach to this problem.
Posted : February 10, 2017 3:53 am
Crystal Report for EMR
This will include all patient who have had a BP taken in prior five years -- an indicator that a current patient. Take a look through the fields to be printed, as you may not need all the fields which we include. Note - we use this Excel file for many things like this.
Posted : February 10, 2017 4:09 am
Another way to handle this without custom programming is to create a letter in Centricity with the patient's address placed at the top to fit into a window envelope. Then just run the inquiry based on age or date of birth, use the Actions option to print your letters, and fold them to show the address in the envelope window. We try to format all Centricity letters like this to eliminate the need for labels.
Julie Dils, North Florida Women's Care
Posted : February 10, 2017 4:15 am
Topic starter
Unfortunately I do not have access to Crystal Reports....
Posted : February 10, 2017 4:32 am
Topic starter
I didn't think of that option. After discussing with the Office Manager I think that is the approach we are going to take. Thank you!!
Posted : February 10, 2017 5:04 am
Yay! I love to help people use Centricity without add-ons. It can save the letter to the chart, too. 🙂
Posted : February 10, 2017 6:43 am
If you have access to run a SQL query, this should work. Paste the results into Excel and you should be able to turn it into a mail merge.
SELECT P.PatientId, P.First, P.Last, P.Address1, P.Address2, P.City, P.State, P.Zip
FROM PatientProfile P
WHERE DATEDIFF(hour, P.Birthdate, GETDATE())/8766 > 65
AND P.pstatus = 'A'
Posted : February 13, 2017 6:26 am
Thank you so much for this!!! I have been working with Centricity for 15 years and have done several mass mailings (docs leaving, etc). WHY HAVE I NOT THOUGHT OF THIS?! It is so funny how we can all be so smart and get hung up by the littlest things. I love this group!!
Posted : June 29, 2017 5:43 am
