?

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?

Anyone?

Comments

( 8 comments — Comment )
sftyson
Oct. 24th, 2007 08:54 pm (UTC)
you're merging the data from rows as opposed to the columns?
esprix
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.
sftyson
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.
esprix
Oct. 25th, 2007 01:00 pm (UTC)
If you stumble upon something, let me know! Thank you!
esprix
Oct. 26th, 2007 01:40 am (UTC)
Someone on the Microsoft community boards posted this link:

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.
sftyson
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?
defenestr8or
Oct. 25th, 2007 12:45 pm (UTC)
When I was in school, Naked Fist Fucking was a 300-level course.

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

Latest Month

August 2019
S M T W T F S
    123
45678910
11121314151617
18192021222324
25262728293031

Tags

Powered by LiveJournal.com
Designed by Lilia Ahner