Log in

No account? Create an account

Previous | Next

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?



( 8 comments — Comment )
Oct. 24th, 2007 08:54 pm (UTC)
you're merging the data from rows as opposed to the columns?
Oct. 24th, 2007 09:59 pm (UTC)
In this particular case, yes. There's information in a row, and then the next row may also have information that's pertinent to the same person, like so:

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.
Oct. 24th, 2007 10:01 pm (UTC)
hmmm, im working from home today, but if you give me a day, i can try some tricks and get back to you tomorrow?

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.
Oct. 25th, 2007 01:00 pm (UTC)
If you stumble upon something, let me know! Thank you!
Oct. 26th, 2007 01:40 am (UTC)
Someone on the Microsoft community boards posted this link:


It looks like it'd work, but it's a bunch of off-the-wall coding to do so.
Nov. 7th, 2007 11:21 pm (UTC)
OK. I've been playing around. So far, the only thing I can think of is to create tables. If you want to be able to sort it varying ways, and include more than one cell of information per person, you will have to create tables for each of the main cells/title cells. Make sense?
Oct. 25th, 2007 12:45 pm (UTC)
When I was in school, Naked Fist Fucking was a 300-level course.

Good times, good times.
Oct. 25th, 2007 01:00 pm (UTC)
The technology's improved.
( 8 comments — Comment )

Latest Month

August 2019


Powered by LiveJournal.com
Designed by Lilia Ahner