I think this workbook will show the labels as you describe. I added the extra warning labels and changed the code to reveal them when necessary.

Attached Files

Mailing Label with help3.xlsm (48.3 KB, 8 views)

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

At a quick look at it, you are nothing short of a magician!

I will change the labels, markings, addresses and colours to what they need to be tomorrow to prove the 'proof of concept' and also have a look at your coding to see how you've worked your magic.

I am pretty damn positive that you've 100% nailed it, and allowed me to be able to put someone in their place, so I can't thank you enough and definitely

Would it be alright if I sent you a private message?

cheers
Mike

Sure, no problem.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Apart from one (hopefully) easily resolved minor glitch of the From and To combo boxes in the User Form auto-populating themselves with the first two rows of info from the Address table, everything else works beautifully!

But even better was the look on someone's face at work - they don't just have one egg of their face, they have the entire tray. It was truly something to behold

The glitch only appears in this version of the User Form. I've been through and triple checked the properties so I'm hoping it's an easily resolved issue. If not then I'll just insert two blank rows at the top of the address table and we can happily roll with that