Select Where To Print On Sheet Of Labels
Hello all. We print one label to a sheet of Avery labels at a time, a few times a week. I want to automate this process using VBA. Going through the object browser, I cannot figure out how to programmatically set which label I want to print to on a sheet of labels. I assumed it would be in the PageSetup or PrintSetup objects, but I can's see where I can set this. Any help would be greatly appreciated.
This might not be as automated as you would like but we reuse label sheets that are not filled up all the way by by the following process.
Set up your vba to generate a csv with enough blank rows and then for the last row (label you want to print on) apply your data. Then in your bartender file set up the database to print the records when it runs. You should be able to print one label at a time and reuse the labels that have not been printed on.0