Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print Multiple Recipients on a Singe Page - MS Publisher

Status
Not open for further replies.

jt463

IS-IT--Management
Nov 23, 2005
134
Anyone know how I need to format a Publisher page to allow me to print a sheet with multiple mail merge recipients on one page?

Here is what I am trying to do...

My Excel Data Source spreadsheet looks like this:

Merge Last First
John S. Smith John
John D. Doe John

I want to print a sheet in Publisher which will result in the one sheet having two records:

Before merge:

<<Merge>>
<<Merge>>

After merge:

John S.
John D.

Every time I complete my merge, the results show the same record multiple times:

John S.
John S.

I checked the MS Help in Publisher 2007...it says there is a 'Multiple Pages per Sheet' print option, but since I am not using labels, and just a single sheet, it doesn't look like that will work.

Any help would be greatly appreciated!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top