Mike



Firstly, get rid of the shapes on the Outer envelope worksheet. They don't add any value and:
- they make the coding harder
- they won't ever align perfectly with the labels coming through the printer so they will look bad

Are you trying to add a new label row to that sheet each time the 'Create new' button is pressed? As in, the first time we fill in row 1, then row 2, then 3 etc until we hit the maximum of 7. If so, why do you expect the user to work out the next available slot (row/col). The macro should be able to work this out by iterating through the cells until it hits an empty one.

What is the point of the labels? Are you trying to be environmentally conscious and feed the same sheet through the printer each time a label is required until all the slots are used? If so, you will need to wipe the 'already gone' slots because the toner won't stick to the exposed backing and it will kill your printer pretty quickly.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Shapes removed in the attached workbook. The cells should match the position and size on the actual Avery label sheet - if not then I will adjust as required.

The start row and start column are going to depend on what labels have already been peeled off the sheet. That was the reason I was trying to be cunning with having the start row / column field on the UserForm.

The labels will be printed on demand so the start row / column could be anywhere on the 'Outer Envelope' label sheet.

I would be happy if, for ease of coding, that the printing always started from column 1 but it would be good to be able to select the start row.

There will only be the 2 inner A5 envelope labels (which is the whole Avery L7068 sheet) and the 2 outer envelope labels (2 of the possible 14 available on the Avery L7163 sheet) printed per use of the template. The chances are that the next time the template is used, the to and from addresses are going to be completely different from the previous use. I hope that explains your queries in your previous post?

And for further clarity - the reason for this whole exercise is that we have to send some stuff double enveloped. The outside envelope address doesn't have the personal details of the person who it is for - those details are on the inner envelope.

Attached Files

Mailing Label v2 - 20_10.xltm (84.5 KB, 10 views)