mail merge labes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am doing a mail merge to create labels from a database that I have in Access. The problem I am having is once the merge is completed, I need to be able to change the format of the labels. I use Avery 5164 labels but they have our logo and business info already printed on them and I need to move the data to proberly fit on my labels.

Please help me if you can.
Thank you,
Nicole
 
Are you using WORD to create the merge from ACCESS? You
would get better help in a WORD or an ACCESS newsgroup.
But, why not insert a transparent placeholder on the return
address, perhaps a couple of letters set to not show or even
the TAB space.


--
The people think the Constitution protects their rights;
But government sees it as an obstacle to be overcome.


| I am doing a mail merge to create labels from a database
that I have in Access. The problem I am having is once the
merge is completed, I need to be able to change the format
of the labels. I use Avery 5164 labels but they have our
logo and business info already printed on them and I need to
move the data to proberly fit on my labels.
|
| Please help me if you can.
| Thank you,
| Nicole
 
Assuming you are using MS Word to produce labels, in the Mail Merge
Wizard, when you get to the "Arrange your labels" section and have
added the required fields to your labels, you will notice that only
the top left label contains the field names - all the other labels on
the page contain the text "Next Record".

Position your cursor on the top left label and before the first field
name then press spacebar once then Enter to add a blank line before
the first field, so moving all the fields down. You can then add
lines/spaces etc to position each field wherever you like.

Then click "Update all labels", "Preview your labels", "complete the
merge", then click "Edit individual Labels" and you will see the
merged document that you can check before printing.

John Allen
 
Back
Top