mail merge for labels with dif data sources for left & right side

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ben - 27 Apr 2006 21:40 GMT

Hello,

I would like to do a mail merge in word where i have 2 labels for the width
of the page. On the right hand side i'd like the info to be taken from one
column in an excel sheet and the info for the left hand column to be taken
from another column in the excel sheet. I've heard it's possible but i can't
figure out how to do this. I'm using office xp but i can also use 2003 if
that helps.

Thanks

Reply to this Message

Doug Robbins - Word MVP - 28 Apr 2006 05:07 GMT

AFAIK, it is not possible. Ask the person who told you that it was how to
do it. Word can only use a single flat file as the data source for mail
merge.

There would be ways to do it using Visual Basic, but not mail merge out of
the box.

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

> Hello,
>
[quoted text clipped - 8 lines]
>
> Thanks

Reply to this Message

Graham Mayor - 28 Apr 2006 06:56 GMT

Assuming that they are different fields from the *same record* in the *same
sheet* then what you want is possible. However you cannot do this as a
standard label merge. You must create a form letter merge using the label
format as the document and manually insert the fields you require in each
cell with a next record field at the start of each left hand cell except the
first. This will allow you to put different fields from the same record in
left and right cells.

Signature

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

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

> Hello,
>
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

Rate this thread: