Print same form with different, listed data

[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).

 

[Pete_UK]

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

 

[My Name Is Tzu How Do You Do]

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.

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

I just thought it might be doable without one.

 

[Gord Dibben]

I think Pete's suggestion of using Word for the mail merge is pretty easy.

But.........If you want it all in Excel, John Walkenbach has some VBA code for
mail merge within Excel.

http://spreadsheetpage.com/index.php/tip/mail_merge_without_word/


Gord Dibben MS Excel MVP

 

[My Name Is Tzu How Do You Do]

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.