Mail merge not lining up

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NANCY - 25 Jan 2004 03:40 GMT

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.

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 25 Jan 2004 04:18 GMT

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.

Signature

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

> When I merge the excel data into my word document, the
> data is not lined up correctly. For example in one row in
[quoted text clipped - 5 lines]
> whole spreadsheet. The amount due is alway off from the
> name.

Reply to this Message