Mail Merge HELP! Physician letter with multiple listed patients and DOB's

[emilypeterson9]

I have a huge project, and I am looking for some assistance. I usually do single entries for Mail Merge, meaning one letter is one row of information, easy peasy. The current project I need to merge is not one row every single instance. I have a list of patients, sometimes the list is one patient, sometimes the list is 30 rows. Each patient has the physician listed. I am sending out notification to the physician, which will include patient name and DOB for each physician. I need the merge to "grab" the physician name, and then list all patients for that physician and list them in individual letters per physician. Am I making sense? Let me insert an example:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Patient Name[/TD]
[TD]DOB[/TD]
[TD]Physician[/TD]
[TD]Address[/TD]
[TD]City[/TD]
[TD]State[/TD]
[TD]Zip[/TD]
[/TR]
[TR]
[TD]Test, Mama[/TD]
[TD]2/2/2017[/TD]
[TD]Abby Lockhart[/TD]
[TD]123 Mail[/TD]
[TD]Flint[/TD]
[TD]MI[/TD]
[TD]48509[/TD]
[/TR]
[TR]
[TD]Claus,Santa[/TD]
[TD]12/25/2000[/TD]
[TD]Gregory House[/TD]
[TD]555 North[/TD]
[TD]Fenton[/TD]
[TD]MI[/TD]
[TD]48433[/TD]
[/TR]
[TR]
[TD]Tree, Olive[/TD]
[TD]9/15/2012[/TD]
[TD]Derek Shepard[/TD]
[TD]22 Shady[/TD]
[TD]Flint[/TD]
[TD]MI[/TD]
[TD]48506[/TD]
[/TR]
[TR]
[TD]Littlical, Annie[/TD]
[TD]1/1/1981[/TD]
[TD]Derek Shepard[/TD]
[TD]108 Main[/TD]
[TD]Flint[/TD]
[TD]MI[/TD]
[TD]48503[/TD]
[/TR]
[TR]
[TD]Erd, Liz[/TD]
[TD]10/31/2001[/TD]
[TD]Derek Shepard[/TD]
[TD]59 Saginaw[/TD]
[TD]Flint[/TD]
[TD]MI[/TD]
[TD]48503[/TD]
[/TR]
[TR]
[TD]Nominator, Dee[/TD]
[TD]07/04/2008[/TD]
[TD]Gregory House[/TD]
[TD]400 Fire[/TD]
[TD]Davison[/TD]
[TD]MI[/TD]
[TD]48423[/TD]
[/TR]
</tbody>[/TABLE]

So, for Derek Shepard I would have a Word Document (which is already set up) that says:


MD,
We are writing to notify you of necessary retesting for the following Patients:


..... And then all of the patients names and DOB's will be listed here.


Can someone help me out? I have over 10,000 patients in my current sheet and I am a little overwhelmed thinking that I can start cutting and pasting if I can't figure it out!

Thanks,</physician>

 

[John_w]

You need what is called a 'Catalogue' or 'Directory' mail merge. See http://support.microsoft.com/kb/294686 and Microsoft Word Catalogue/Directory Mailmerge Tutorial | Windows Secrets Lounge for instructions.

As noted in the MS article you will first need to sort your data by the Physician column so that the rows for each physician are grouped together.