Esprix (esprix) wrote,

  • Mood:

A question about Word mail merges

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?

Tags: computer, how to, work

  • Weekend with Ray

    Had a great, long weekend with Ray. Things are going well. :) I went to work on Thursday, and Ray came down late that night. Friday he went in with…

  • Today

    Got a long to do list at work but feeling like I'm not getting anything done today. Yesterday I got treated to bagels for Secretaries'... er,…

  • Would you look at that?

    Gosh, look at all those job openings at UCSD...

  • Post a new comment


    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded