I've got a Excel macro that is currently doing an adequate job,
but it is pretty simple. It takes a Range F4:F6 and sends it to
MS Word pasting it into a new document, then automatically
brings up the Print Envelope Dialog with the data populated.
I only have to click the Print button.

I need to expand the simple 3 line scenerio to as much as 5
lines, but only certain addresses require all 5 lines. How would
I begin to allow for this? In Excel or in Word? TIA, Jim