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

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.

--
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

"Ben" wrote in message
...
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

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.

--

Graham Mayor - Word MVP

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


Ben wrote:
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