Mail Merge Problem

[Marcus]

Using Office for OSX. Mail merging data from an Excel spreadsheet into my
created mail merge document. When I enter the number of the
spreadsheet record I want to view in my mail merge document, it takes me
to a record other than the one I typed into the little window in the Data
Manager. How do I get the correct record to merge into my document
when I type in the number of the record I wish to merge? I would
appreciate any ideas. Thanks.