Mail merge not lining up

[NANCY]

When I merge the excel data into my word document, the
data is not lined up correctly. For example in one row in
excel is all of the data relating to a customer (name
address, amount due ect). When we do the merge, the first
statement shows the name and address for the first person
in row two from the excel sheet, but the amount due is
from the next person in row three. This continues for the
whole spreadsheet. The amount due is alway off from the
name.

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Nancy,

Sounds like you might have a <<Next>> field before the amount field in the
mailmerge main document. You are probably only getting every other customer
as well.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP