I've copied the code into the project but I'm not seeing anything happening on the outer envelope worksheet.



I've added some text on the 'Inner envelope' and mocked up on the 'Outer envelope', what address would go where if Row 1 / Column 1 (or should that actually read column A) was input in the UserForm to clarify my poor attempt at explaining what I am hoping can be done.

Would it be better to (is it even possible?), once the address has been copied from Inner envelope Column D, then it is pasted in as an 'Edit Text' for the applicable shape?

Or would it be better to remove the shapes altogether and paste to the address into the required row / column cell?

I am wondering if it would be easier to just say that the To address will always go in column A and that the From address will always go into column C (with column B being the spacer between the labels)?

I am now rambling and just throwing ideas out there to people who are WAY more knowledgeable on what is possible with Excel.

Attached Files

Mailing Label v2 - 19_10.xlsm (90.2 KB, 6 views)