Word Mail Merge Using Excel Database To Create Mailing Labels

  • Thread starter Thread starter Sherri Zat
  • Start date Start date
S

Sherri Zat

Hi,

I created a database in excel to use a mail merge main
document, everything merges alright, but the data isn't
set up on the label properly. When i try to edit the data
in a particular label the data is still not printing out
properly, even though it looks fine on screen.

Help, Please!

Thanks,
Sherri
 
Sherri,

do you have the backwards P clicked? This would allow you to see non
printing characters which may be your problem.

Are you in page layout view or normal view. Try switching to Page Layout.

also have you aligned your label with Tabs or spaces. One of the major
issues for new users is fixed anbd variable pitch fonts. this is a highly
technical term for the space each character takes up. In a fixed pitch font,
an "l" and an "m" take up the same amount of space along the line of text.
In a variable pitch font, l's take up less space than m's. So, if you use
spaces to align fields in a document they will usually not line up when
printing.

HTH

Steve
 
Hi Sherri,
I created a database in excel to use a mail merge main
document, everything merges alright, but the data isn't
set up on the label properly. When i try to edit the data
in a particular label the data is still not printing out
properly, even though it looks fine on screen.
Click to expand...
If Steve's suggestions haven't helped:
1) Which version of Word
2) Please describe HOW it's not printing out correctly
3) Note that some versions of the Avery label wizard (which
is what's going on behind the scenes) were faulty. You might
check the Avery website for an updated version for your
version of Word and see if that helps.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)
 
Back
Top