Howdy all,
I would like to set up a mail merge that goes like this:
Its from an access query with two tables:
Table 1 has ID, Name, Address, City, State, Zip
Table 2 has ID, Patient Name, Date of Birth & Date of Service
The query links the two tables by ID and returns about 600 records with duplicated info from Table 1. (i.e. If in table 1 there is Jon Smith listed once, but he saw 10 patients, the end result of the query will be Jon Smith listed ten times next to each patient.
I would like to create a mail merge in which I send Jon Smith 1 piece of mail with a list of each patient, date of birth, & date of service in a table.
My efforts have only produced ten letters to Jon Smith one with each patient listed. I've tried using the Insert Word Field "Next Record" and got excited momentarily but then noticed it just kept going for names other than Jon Smith.
Please let me know if anyone has had success with this. I was considering just doing a report in Access that grouped the patients together but it's for a document that has to be in a word format... argh...
Any help would be greatly appreciated. Let me know if this makes sense. Thanks!!
I would like to set up a mail merge that goes like this:
Its from an access query with two tables:
Table 1 has ID, Name, Address, City, State, Zip
Table 2 has ID, Patient Name, Date of Birth & Date of Service
The query links the two tables by ID and returns about 600 records with duplicated info from Table 1. (i.e. If in table 1 there is Jon Smith listed once, but he saw 10 patients, the end result of the query will be Jon Smith listed ten times next to each patient.
I would like to create a mail merge in which I send Jon Smith 1 piece of mail with a list of each patient, date of birth, & date of service in a table.
My efforts have only produced ten letters to Jon Smith one with each patient listed. I've tried using the Insert Word Field "Next Record" and got excited momentarily but then noticed it just kept going for names other than Jon Smith.
Please let me know if anyone has had success with this. I was considering just doing a report in Access that grouped the patients together but it's for a document that has to be in a word format... argh...
Any help would be greatly appreciated. Let me know if this makes sense. Thanks!!
