Hi ....,
I think your problem is that you don't have titles at the top of each column.
For step by step instructions to do mail merge to print labels see
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

Also make sure that your worksheet is at the first worksheet tab, drag it there
if it is not.

If not labels the letters, and envelopes are much the same, but you can refer
to one of links on the above page to a Microsoft Word oriented presentation.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"junoon" wrote in message ups.com...
hi all,

i have an excel worksheet which has some data a row. the last column in
that row is for email addresses. i am entering multiple email addresses
in
a single cell. when i click one of the email addresses in that cell, it
should transfer all the email addresses into a word mailmerge document
which i am printing for multiple users.

But when i click, only the first email address comes into the field in
the
Word Mailmerge document.

Please note that I dont want to place each email address in a single
cell
in that last column as one row needs to have multiple email addresses.

I also donot want to merge each cell in a column with the one below it,
inorder to have the last column showing each address in each cell one
below the other.

PLEASE HELP ASAP