Print same form with different, listed data

  • Thread starter Thread starter My Name Is Tzu How Do You Do
  • Start date Start date
M

My Name Is Tzu How Do You Do

Hi.

I want to make a worksheet that has a print area definition which
prints an invitation.

I want to place lookups in the name field, and perhaps a couple others.

I want to print the form, and have the print-out print a single
"invitation form" for each name in the list.

Is this possible without VB code?

Is there a way to simply perform a print job that expands based on the
contents of a column of cells?

I mean, I know that I can define a print area, and make a list that
prints great with repeating headers, and repeating footers, etc.

Those I can format just fine.

In this case, I want to send a single print job, and have it print
a given form once for each entry in the list.

I suppose I could place multiple forms and have them only appear if
they contain data. Not sure how easy that is either.

Anyway, the goal is to make a single form, and have it print once for
each entry in a list contained elsewhere with that list's data inserted
into the form at the time of each print segment. (another worksheet).
 
You could use your data list in Excel as the source and then print out
the invitations in Word as a mail merge.

If you really want to do it all within Excel then you wold need a
macro.

Hope this helps.

Pete
 
You could use your data list in Excel as the source and then print out
the invitations in Word as a mail merge.

If you really want to do it all within Excel then you wold need a
macro.

Hope this helps.
Click to expand...


Thanks. What? A simple "for each" macro? If so, that is easy.

I just thought it might be doable without one.
 
Except that this is not an email list.

I'll have to do the for/each macro. I want hard print jobs
nuthin' about word or mail.

Thanks, guys.
 
Back
Top