Merge Word doc w/specific rows of Excel spreadsheet

[MarciaH]

Hello - I'm trying to merge a Word letter with an Excel
spreadsheet that has 1038 rows -- However, I only want
the letter merged with every 3rd row (rows 2, 5, 8, 11,
etc.). How do I accomplish this?
Marcia H.

 

[Cindy M -WordMVP-]

Hi MarciaH,

I'm trying to merge a Word letter with an Excel
spreadsheet that has 1038 rows -- However, I only want
the letter merged with every 3rd row

Is there any common factor that identifies these rows,
other than "every third"?

If not, your best bet might be with a catalog merge type
that has "Next Record" inserted at the very beginning and
very end of the letter (with a Page Break just before that
last one).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

 

[Marciah]

-----Original Message-----
Hi MarciaH,

Is there any common factor that identifies these rows,
other than "every third"?

If not, your best bet might be with a catalog merge type
that has "Next Record" inserted at the very beginning and
very end of the letter (with a Page Break just before that
last one).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e- mail


.
The only common factor -- well really isn't -- but the

last column is a counter.. i.e. the first row /last
column would contain the "word" 1000, next row, last
column would contain 1001.etc.
Marcia

 

[Cindy M -WordMVP-]

Hi Marciah,

The only common factor -- well really isn't -- but the
last column is a counter.. i.e. the first row /last
column would contain the "word" 1000, next row, last
column would contain 1001.etc.

I can't think of any way that can be used to filter the
records. I take it there's no way in Excel that you could
filter them, either, to see only those you want to merge?

If not, then you'd need to do something along the lines I
suggested in my last reply. For example, if you want to
merge rows 3, 6, 9, etc. insert two "Next Record" fields at
the very start of the main merge document. (From the
"Insert Word Field" button on the mail merge toolbar)

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail