you merge the data in your (untold) data source and the spreadsheet BEFORE you do a mailmerge with Word, and NOT afterwards.
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.