F
Flyer7
Good evening,
I'm merging data into certificates for an organization using Excel and
Word 2003. In the past a simple merge of one data row created a
document with mailing address, name and achievement in each merged
document. Many members end up with several certificates.
This year I was asked to reduce the number of certificates to one
certificate for any one individual, and include all the achievements
for a single individual on one certificate. Names may repeat for
several rows, each with a different achievement. I'd like to place
data from subsequent records onto the current merge document as long
as the name remains the same. New name = new document.
Would I use bookmark to "hold" the current record name for comparison
with the next record? Then how do I jump to next document if name is
different?
Any help would be appreciated.
I'm merging data into certificates for an organization using Excel and
Word 2003. In the past a simple merge of one data row created a
document with mailing address, name and achievement in each merged
document. Many members end up with several certificates.
This year I was asked to reduce the number of certificates to one
certificate for any one individual, and include all the achievements
for a single individual on one certificate. Names may repeat for
several rows, each with a different achievement. I'd like to place
data from subsequent records onto the current merge document as long
as the name remains the same. New name = new document.
Would I use bookmark to "hold" the current record name for comparison
with the next record? Then how do I jump to next document if name is
different?
Any help would be appreciated.