Mail Merge Import Issue between Excel 2003 and Word 2003

[gbaker101]

I am doing a mail merge file in Word 2003 that imports from an Excel spreadsheet. The issue I am having is that it is not importing the data in certain columns from the spreadsheet into the Word document. When I bring up the Mail Merge Recipients List in word, and scroll through the data, there are certain fields that are blank and should have data, and since it is only certain columns where the data is not being imported, I'm assuming the issue lies somewhere within my Excel spreadsheet or possibly what I'm using as the column header label for these columns. The data in these columns is numbers, and I've tried reformatting the cells to different types (general, number, accounting) with no success. Any thoughts or suggestions on what is causing this from the Excel gurus out there is appreciated!!

 

[pbornemeier]

Change a few of the numbers to words and see if the words transfer properly. Perhaps the column names are not being matched to the merge fields properly.

Try adding a helper column that puts a space on either side of the number and see if
that merges properly.

 

[Sanjeev1976]

Relink the excel file and see if this helps. Most of the time I have found a problem, this does the magic.

Sanjeev