Have had a chance to have get the code in the right places - should have clicked that having 'Call labels' was meant to be in a module. I originally had it in the UserForm code...whoops!
Couple of things that I hope you can assist with resolving... the 'to address' for the outer envelope label is getting picked up from the ToFrom worksheet when it should be getting picked up from Column D on the Inner Envelope worksheet.
Selecting Column 1 works fantastic but nothing appears if Column 2 is selected?
And there is no 'from address' appearing on the outer envelope label?
Have reattached an updated worksheet with the coding you have kindly assisted with so far.
|