mail labels

[BorisS]

I have very carefully made a sheet divided into label sizes that I'd like to
print, only to realize mail merge in Publisher can only handle one set of
fields per sheet, as opposed to different records within the same sheet.
Someone please tell me I'm wrong, as the process of getting the lineup of
label margins was excruciating.

If there is a way to access records and get them to print from top to right
or top to bottom on a single page (continuing on subsequent pages with
subsequent records, of course), then please speak now, so I am not back to
square 1.

Thanks.

 

[Mary Sauer]

Mail Merge works perfectly in Publisher and can do what you are asking about.
What version Publisher do you have? Print preview will show all the labels being
the same, this is an infamous Publisher bug. You can print a sample from the
print dialogue if you are unsure. This bug is not evident in Publisher 2007.

 

[BorisS]

Mary, I'm relieved on the one hand (that I have the right layout, and can
accomplish the print), but frustrated on the other (I have '07). If you can
guide me, I have to get this done before the next few hours, and would be
most grateful.

What I've done so far is the following:

1) defined a table in the page
2) created an mdb file with all my information
3) went to tools, mailings and catalogs, mail merge, and inserted the fields
into EACH of the table cells (maybe this is where I went wrong)

Now, on both the regular and print preview document, what I see is the same
entry repeated over and over, until I indicate I want to "preview recipient"
next button, and then I see a page of the next ones.

Any help?

 

[BorisS]

also, when I do print a test, it does still unfortunately do what I'm
indicating, which is print a sheet of 12 of the same label, and then the next
sheet of the next label.

I'm panicking a bit.

 

[DavidF]

I think maybe Mary misread your original post. You should have only one
label on your publication...not a whole sheet of labels. This is a FAQ, and
you can scan the newsgroup for more answers and instructions, or Reference:
Mail and catalog merge :
http://office.microsoft.com/en-us/publisher/CH062524751033.aspx

DavidF

 

[BorisS]

so if I'm understanding correctly from the MS site (which I'd previously
seen) and the further suggestion in your response, you cannot do what MS Word
does, in terms of a "next record" indicator, so that the publication knows it
needs to pull a next record before entering the follow-on fields. Correct?

Only reason I am in this position is because I could not get Word to behave
when trying to adjust margins and label sizes. And for some reason, I
finally got Publisher to get the margins and borders to match exactly onto
the label pages I needed. Otherwise, Word is obviously a better choice for
this.

So please just confirm...no way to get multiple records onto one page?

 

[Mary Sauer]

In Publisher 2007, file, print merge, be certain you have "multiple pages per
sheet" checked. Publisher is very good with labels especially if you have to add
a graphic.

Have you tried merging to a new publication in step 3? Here again when you are
ready to print you must specify multiple pages per sheet, but you do a straight
on print, not print merge.

 

[Brucels]

Boris,

The fact that you have created an mdb file suggest that you have Microsoft
Access. If so, why not do your printed as a report from Access? If I
understand your original post correctly, that should be a simple thing to do.

Bruce