make file folder labels from Excel to Word using Mail Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Montreal - 22 May 2008 07:28 GMT

I am trying to make file folder labels using mail merge and my data source is
an Excel spreadsheet. I have three columns. I want the first two columns to
the far left of the label and the third colum to the far right. I've tried
everything when I match fields, but nothing seems to work and I'm not sure if
it is even possible. Could someone take me through the steps? Thank you!

Reply to this Message

Graham Mayor - 22 May 2008 09:48 GMT

Put the first field at the left of the cell, the second at a left aligned
tab stop, the third at a right aligned tab stop at the right margin. Clue -
use CTRL+TAB to tab within a table cell.
See also http://www.gmayor.com/mail_merge_labels_with_word_xp.htm or
http://www.gmayor.com/merge_labels_with_word_2007.htm

Signature

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

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

> I am trying to make file folder labels using mail merge and my data
> source is an Excel spreadsheet. I have three columns. I want the
> first two columns to the far left of the label and the third colum to
> the far right. I've tried everything when I match fields, but
> nothing seems to work and I'm not sure if it is even possible. Could
> someone take me through the steps? Thank you!

Reply to this Message