mail merge problem in publisher

[sue]

I recently had to reload Office Small Business 2007 onto my computer and now
my publisher document won't merge with my excel spreadsheet. When merging
the spreadsheet with over 100 address I only get one page and one address.
Previously I got one page for each address. I'm sure it's a setting but
which one?

 

[Mary Sauer]

Are you doing labels? Do you intend to have multiple names and addresses per
page? Your problem isn't too clear.

If you are doing labels or similar:
After you input your fields go to File, Print Merge, be certain "Multiple pages
per sheet" is selected. There is a print preview on this screen.

 

[sue]

No what I am doing is an invoice. I am merging it with a client list from
excel. I want one invoice to be printed for each client from the list

 

[Mary Sauer]

It would be about the same except once you have your merge fields in place on
your invoice, File, Print Merge, it should say One page per sheet. And you
should be able to print preview all 100 invoices from this screen.