Mail Merge results to one page

[Sweeper]

Hello Experts,

This is what I am trying to accomplish:

I use Publisher to create 4 x 6 labels and I decided that I want to become
more efficient. I have merged my label to an excel spreadsheet. I am grabbing
data from two fields within the excel spreadsheet. I have used a filter to
filter out the ones I don't want. Everything works except one thing.

When it comes time to print, it print one merge result to one label. So if I
have five results, it will print 5 individual labels for each merge result.

I want to be able to print all five results to just one label. Is this
possible?

Irwin.

 

[Mary Sauer]

Are you putting the results of all five of the merge fields into one text box?

 

[Mary Sauer]

Me again, are you using the same database for your merge?

 

[Sweeper]

Mary,

I am not sure how to answer your question, but I will try. Within the label
layout, I have the following fileds shown:

P.O. Number: <<PONUM>>
------------------------------------------------------------
Style: Qty:
------------------------------------------------------------
<<VendStyle>> <<Q1>>




------------------------------------------------------------

The label looks something like this.

Hope this helps,

Sweeper.

 

[Sweeper]

Mary,

Yes I am.

Sweeper.

Me again, are you using the same database for your merge?

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

 

[Sweeper]

Mary,

Yes I am using the same database for my merge.

Sweeper.