creating labels, not addresses, from an Excel file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

some_guy79 - 11 Jun 2005 01:09 GMT

I have excel files that I would like to extract information from and put it
onto labels. I've tried to use the Mail Merge function in Word to do this,
but have had no luck.

Right now when I preview or print labels I get a sheet full of labels with
"<<Next Record>>" printed on each label. The label in the upper left corner
is blank.

Also, is there a way to use only certain columns of an Excel sheet as data
to be included in the label?

FYI, I am using MS Office 2003 versions of Word and Excel.

Reply to this Message

Graham Mayor - 11 Jun 2005 03:54 GMT

See http://www.gmayor.com/mail_merge_labels_with_word_xp.htm which should
address all your questions. The megre will use whatever fields (columns) are
available in the data file. They don't have to be addresses.

Signature

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

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

> I have excel files that I would like to extract information from and
> put it onto labels. I've tried to use the Mail Merge function in Word
[quoted text clipped - 8 lines]
>
> FYI, I am using MS Office 2003 versions of Word and Excel.

Reply to this Message