Mail merge - Word V.X and Excel V.X for Mac

[Sean Chandler]

I am (almost) successfully mail merging from an Excel s/s into a Word
Doc.

The source Excel s/s contains approx. 40 records - the Word merge doc
contains 45 rows (9 pages) of merge fields - the first field in each
row is «Next Record If» «NAME». NAME is the first column in my Excel
s/s source file.

The problem is that the *merged* document is 35 pages long - the
first 40 records are accurate, the rest are blank.

I was hoping that the «Next Record If» field code would stop the merge
when it hit a blank field in the Excel s/s

I donot wish to restrict the merge doc. to 40 rows as the number of
records in the source Excel s/s does not remain constant.

I can specify a cell range during the mail merge operation to limit
the merge to only those rows containg data, however the *merged*
document still contains a couple extra pages of empty rows.

Is there another way to limit the merge to only those rows containg
data in the Excel source s/s?

Thanks

 

[Cindy M -WordMVP-]

Hi Sean,

I'm not familiar with the exact functionality the Mac offers, but I
*think* if you choose "Catalog" (or "Directory") as the type of mail
merge, and then create only a SINGLE row with the merge fields (and one
empty paragraph mark beneath that row), you'll get the result you're
looking for.

I am (almost) successfully mail merging from an Excel s/s into a Word
Doc.

The source Excel s/s contains approx. 40 records - the Word merge doc
contains 45 rows (9 pages) of merge fields - the first field in each
row is «Next Record If» «NAME». NAME is the first column in my Excel
s/s source file.

The problem is that the *merged* document is 35 pages long - the
first 40 records are accurate, the rest are blank.

I was hoping that the «Next Record If» field code would stop the merge
when it hit a blank field in the Excel s/s

I donot wish to restrict the merge doc. to 40 rows as the number of
records in the source Excel s/s does not remain constant.

I can specify a cell range during the mail merge operation to limit
the merge to only those rows containg data, however the *merged*
document still contains a couple extra pages of empty rows.

Is there another way to limit the merge to only those rows containg
data in the Excel source s/s?

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

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