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