Can I repeat data from one record on all records in a mail merge?
January 27, 2011 1:46 PM Subscribe
Looking for a word/excel mail merge trick that may not exist. Basically, what I'm looking to do is put information from the header row itself into the merge document so that it appears in the merge for each other record.
posted by robverb to computers & internet (4 answers total) 1 user marked this as a favorite
In other words, row 1 in Excel (which I'm using for the data source for my merge) would have the the criteria that I am evaluating a project on (e.g. content, spelling, sources used, etc) and rows 2 through 25 would show my students' names and their scores for each category. If I were only doing this once or twice, the obvious solution is to just type the criteria directly into the merge document. But I want to be able to do multiple merges each day without having to create new merge documents. I'm using excel and word 2003. Any thoughts?