Mail Merge has extra sheets

[Gene Augustin]

I have a mail merge document that uses an Excel Spreadsheet for the merge
fields.Everything was fine until I removed some of the records in the spread
sheet (made them blank cells). In the beginning of the year, I only have one
record to merge (why merge?). However I add a record every few days. Now,
with only one record, If I preview, the record is there plus 4 form letters
with no data in the merge fields.
How do I reduce the number of merge records to the number of records in the
spreadsheet? I know I can do "CUSTOM" in the merge, but then I would have to
do them one at a time.

Gene

 

[CyberTaz]

My guess is that the empty rows are still considered a part of the data
range since they were previously included. In the Excel sheet try selecting
the empty cells below the record then go to Edit> Delete to effectively
replace the cells with fresh ones rather than "empty records". Once you save
the file do the merge again & se how it works.

HTH |:>)
Bob Jones
[MVP] Office:Mac