Changes are not reflected when merging using Excel as data source

[Jennifer Mcdermeit]

I am performing mail merge in Microsoft Word, with an excel worksheet as the
data source. The merge function works fine, but whenever I make changes in
the excel worksheet, the new changes in the worksheet are not reflected in
the Word form, only the previously saved changes are shown. I am saving the
excel worksheet after making the changes. I can't figure out why my changes
are not shown in Word when I perform merge, please help!

Thank you,
Jen

 

[Doug Robbins - Word MVP]

Please explain exactly what steps you are taking to execute the merge after
having saved the Excel file.

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

 

[Jennifer Mcdermeit]

1) Open excel data source, make changes to cells & hit save
2) Open word form and then click the icon "Merge to New Document"
3) Select all records & ok
4) Merge works, but changes aren't reflected. Only previous merged items
are merged into fields