For my Microsoft-proficient friends, I have a question.
I'm doing a mail merge in Word from an Excel source. In the spreadsheet there are sometimes more than one row associated with the same person (multiple rows are always after each other in the spreadsheet). I want to be able to merge all the relevant rows of data for each person into one page of the merged Word document, whether it be one row or four.
The person I replaced in this position seems to have figured it out for the same merge last year, but for the life of me I can't figure out how he did it. I'm thinking there's a {nextif} statement I need to use somewhere, but I'm not sure. Usually in the data I've worked with in the past all the data for each entry was all in the same row, but that's just not how I had the information presented to me. Plus, it's obvious it can be done, but how?
Anyone?
- Current Mood:determined
Profile
esprix- Esprix
- My online photo album
Comments
Adams, John Psychology 101
Adams, John Physics 101
Adams, John Chemistry 101
Beckham, David Calculus 101
Caligula, Emp. Doodles 202
Caligula, Emp. Naked Fist Fucking 400
Dumbell, Mr. No Idea 101
Get it? So I want all the stuff for Adams, John to appear on one page, whereas a Word merge will attempt to break it into 3 different records.
oh and after im done with my tricks, i'll work on your situation...just kidding....i've never tried to do a mail merge pulling data from a row instead of the columns.
http://support.microsoft.com/Default.aspx?kbid=294686
It looks like it'd work, but it's a bunch of off-the-wall coding to do so.
Good times, good times.