Hello!



I hope somebody can please help?

I have a data source file of address/company names, etc, using Excel which I've pulled through into Word for a mail merge. My question is if I only have one field called 'Company file' and only one field called 'Address', why would the address in Word match the first row I have on my data source file in Excel but when I use the Company file field, it's picking up the company on the second row of my data file in Excel. It's basically mixing the information up between one row and the next.

Is this even possible? If so, what would I have had to do wrong?

Thanks,

Lisa.

It's difficult to tell without seeing it. Are you merging to letters, or something where there's more than one (label, table, etc.) per page?

Look for a stray <<Next Record>> in your Word template. And, of course, check your Excel source for any stray information, including hidden rows or columns.

Also be aware that when you do a preview of results, things don't always look right. For example, if I'm doing a merge to two tables per page, it usually shows me 1 and 2 on the first page, 2 and 3 on the second, etc. in preview mode only. When I do the actual merge things generally look right.

Ann