Printing envelope - 5 line addresses

  • Thread starter Thread starter Jim May
  • Start date Start date
J

Jim May

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
 
The usual recommendation for this sort of job is to use Word's mail merge
facility, taking input data from Excel. The usual format of the data in
Excel would have the fields for one address in columns across a row, with
the next address on the next row.
 
Thanks David,
Further, I am wanting to "move-up" say my last line if
Line 3 and 4 are blank for the record. I'll look over in
the Word Newsgroup for more info.

Jim
 
Jim

When doing the mailmerge in Word you will find the option to ignore blank lines
in source data.

Thus line 5 would "move up" to join lines 1 & 2


Gord Dibben MS Excel MVP
 
Gord -- Is this feature in 2003 (or 2007)?

Gord Dibben said:
Jim

When doing the mailmerge in Word you will find the option to ignore blank lines
in source data.

Thus line 5 would "move up" to join lines 1 & 2


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top