View Single Post
 
Old 10-14-2021, 03:03 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,969
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
Reply With Quote