Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2006

Tip: Looking for answers? Try searching our database.

Make 2 NAME lines for  Avery 5160

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
kimmer - 24 Aug 2006 03:21 GMT
I need to print address labels like this:

Parent  first and last names on line 1
Student first and last name on line 2
Address on Line 3
City St Zip on Line 4

I guess I could just put student's first and last name into one cell and
name it Company Name so that it would print out on line 2 of a label.  But
how do I set up a custom label template using my student first and last name
cells on Line 2?

I have Word 2003. Thanks in advance!
Kim
Doug Robbins - Word MVP - 24 Aug 2006 04:32 GMT
I gather that you are using the AddressBlock.  Instead of using that, just
insert the individual mergefields that you want to use in the configuration
that you want them.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I need to print address labels like this:
>
[quoted text clipped - 11 lines]
> I have Word 2003. Thanks in advance!
> Kim
kimmer - 24 Aug 2006 05:15 GMT
> I need to print address labels like this:
>
[quoted text clipped - 10 lines]
> I have Word 2003. Thanks in advance!
> Kim

Thanks for the tip. Now when I choose More Items instead of the Address
Block set up for my labels, I do find my other fields. Now my question is,
when I choose Match Fields as the next step,, my student 1 and student 2
cells are not listed as choices to match.

Also, when I insert my own database fields on the 5160 label, how do I move
to the next line when I'm adding the fields? When I press enter, it just adds
the same information again, and when I just keep choosing fields, the fields
just keep wrapping.
Graham Mayor - 24 Aug 2006 07:48 GMT
There is no matching of fields involved! Just insert the fields directly
into the labels - see
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

>> I need to print address labels like this:
>>
[quoted text clipped - 20 lines]
> enter, it just adds the same information again, and when I just keep
> choosing fields, the fields just keep wrapping.
kimmer - 24 Aug 2006 13:54 GMT
> There is no matching of fields involved! Just insert the fields directly
> into the labels - see
[quoted text clipped - 27 lines]
> Thank You! Thank You! After reading your comment now I can place anything I want on labels! Sometimes I get stuck on the tiniest details - and your answer was a real DUH!
> I'm so glad this board is here!
Kim
Peter Jamieson - 24 Aug 2006 08:28 GMT
(Just in case) make sure you have the Database Fields radio button selected
at the top of the Insert field dialog box, not the Address Fields button. If
you use the Database fields button you see the fields that are actually in
your data source. If you use the Address fields button, you see a
standardised list of names that you then have to map to the actual names in
your data source.

Peter Jamieson

>> I need to print address labels like this:
>>
[quoted text clipped - 25 lines]
> fields
> just keep wrapping.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.