excel data not avilable for mail merge

[Rita]

I have an existing excel spreadsheet I have used for mailmerge into word
document. If I change the data or add a column of data, save it, go back to
work to merge a new document, the changed data or added data does not appear
in the "insert merge fields" so I can insert them into the document.

 

[Kevin B]

When you open your merge document, do not connect to the datafile.

Once you're in the document you can click TOOLS and step through the mail
merge process until you reconnect with the Excel Data file. At that point
your newly minted merge fields should be available.

Additionally, there is a mail merge forum on the Word site that would more
beneficial for you to post in, as your problem lies with Word and not with
Excel.

Hope this helps.