If you are getting additional unexpected rows from the source data in Excel then you need to look at how the source range is defined. Excel often has a 'used range' for a spreadsheet but it may also have a defined 'table' (aka List Object). It is likely that these areas are acting as the source range.
The easiest fix would be to select the rows immediately under the data in Excel and delete those rows. This will effectively collapse the range that is serving as the source for your mail merge. Note that if you have hundreds of extra records then you will need to delete hundreds of extra rows in the source worksheet.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|