you merge the data in your (untold) data source and the spreadsheet BEFORE you do a mailmerge with Word, and NOT afterwards.
Kees
Description: i have a word file with a mailing list and fields inserted into the document. I can move up and down the mailing, what causes the fields to change accordingly.
I also have a excel file with a value in each line that corresponds to each person in the mailing.
What i want is to while in word and cycling the mailing, for each name that show?s up, the value from the corresponding excel line is showed.
I have used linked fields to show the contents of one cell in the word document, but it?s always the same.
Maybe it?s possible by placing a field in the mailing with the corresponding excel line number, so that it updates the cell from wich it is getting the values.
Any Ideas?

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic