You must have each field in a separate cells across the row.
Make a copy of the worksheet (remember must be the first worksheet tab).
Use Data (menu), Text to columns to separate at semicolons
- choose delimited in the first dialog
- use semi-colon as the delimiter
---
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 David,

sorry, I guess i was not clear before.

The Excel workbook has only 1 worksheet & i.e the worksheet which i am
using to put data into fields on a word Mailmerge document. the excel
sheet has been selected as the Data source. All the data are coming
into the word document..no problems, except the email addresses, which
i have entered (separated yb semi-colons) into a SINGLE CELL in the
worksheet. Only the 1st email address appears in the field in the
mailmerge document, not the others.

I want to get all the email addresses to show in the field in word,
whenever i click on an email address in the single cell of the
worksheet.

Rgds,

Junoon