If you believe this to be a Word VBA solution I will try and find a Word coding forum in which to ask this question.Ī year ago I came up with an automation “mini-app” that staff can use to generate the correct number of student aide tags needed for the student aides helping them in their classes.
#HOW TO MAIL MERGE LABELS FROM EXCEL TO WORD 2000 CODE#
The actual mail merge is being performed using Microsoft Word VBA code (as I ran into far too many problems in executing the mail merge in Excel) while the Excel VBA code is used for showing/hiding cells, clearing the form, determining the number of printed pages in the final step, and saving and continuing the next step in the mail merge process.įull details to follow and I’d be more than happy to upload screen captures if that would be of help. 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.