![]() In Excel/Word 2002 and beyond, this no longer seems to work, however, one peculiarity seems to make me thing perhaps Excel 2002 and beyond is still capable of limiting a mail merge data source range in this way.Īny ideas of how I might either modify the Excel or Word documents or the VBA code so that only shown/filled rows are included in the mail merge, thus eliminating unnecessary blank pages? This also added simplicity to the Excel “form” by showing the user only rows needing to be filled out at the time. In Excel/Word 2000 I was able to achieve this by hiding unused rows in Excel before performing the mail merge. I am running into a problem specifying a mail merge range in Excel 2002/2003 that only includes non-blank cells.
0 Comments
Leave a Reply. |