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!
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!