I am using Excel as a data source for a mail merge letter. When I run the merge, I get 5 blank letters at the end (i.e., the form text is there, but none of the variable information. When I went to the Excel worksheet, I realized that those 5 blank rows show up when I go to the first cell and select the whole worksheet (I use the keyboard, Ctrl + Alt +End). I have tried deleting these rows, clearing these rows, deleting the cells and letting the cells remaining cells shift to the left, then up from the bottom. I even tried deleting all the blank rows after the data to the end of the worksheet. I also tried setting this as a print area.
Finally, I copied and pasted the data rows into a new worksheet, but I still have one blank row at the end that gives me a blank letter in the final document.
Because of the section breaks I have in the document, deleting the blank page and the next page section break in the final document changes the formatting. Not that I can’t work around that, but I’m frustrated with trying to get rid of these blank lines.
Why are they showing up as data in the worksheet, even after I delete them?
I’ve not seen this before, and I use Excel a lot for mail merges. I searched the MS Knowledgebase, but didn’t find anything like this. I usually would search the lounge to see if anyone else has this problem before asking for help, but as we know, it’s not available.
Thanks for any ideas.
Tia