Missing data in a Merge Document

[Guest]

I have been having issues with missing data in a mail merge document. I have
pasted a lot of data into a Excel spreadsheet which i am using for a mail
merge. When I complete the mail merge process in Microsoft Word some of the
fields only display half of the information that is in the cell of the Excel
document. The data in the Excel spreadheet has been copied from various
Microsoft Word documents it is not in single lines (eg. may include line
spacing/returns) but the data appears fine in the Excel spreadsheet. I
thought that the data may contain strange formatting but I have removed the
formatting from the Excel spreadsheet and from the field codes in Microsoft
Word but this does not fix the problem. Please help!

 

[Guest]

Hi,

Clean your excel document. Also check whether each and every data you copy
from the Microsoft Word document in to Microsoft Excel properly corresponds
to each field.

Note: Check for merged cells in Microsoft Word data in to Excel data.
Although the data is delimited by Tabs the data is not poperly stored in the
Excel. Clean the Excel document, before mail merging. Just mapping the Field
is not sufficeint. Accuracy of data while merging is important. A data shift
in one cell will provide redundant data.

Challa Prabhu