Mail Merge with Excel shows incorrect results

J

Jan

I have a merge with an Excel file and because I need the formatting from
Excel in the Word document I need to select MS Excel Worksheets via DDE.
However my merge results have shifted down one in my table. In other words
the result which should be in the first row is in the second row, the second
row in the third, and so on and so on yes the merge fields are in the correct
cell of the Word table. However, if I switch back to OLE DB Database Files
the merge shows correctly with the first field in the first row, etc. Does
anyone have a resolution to this problem?
 
J

Jan

Peter:
Thanks for trying to help but I solved my problem. It appears there can be
no blank column headings in the Excel file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Mail Merge Directory Conditional Page Break 0
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Merge Excel file into Word Document 3
Page numbering with Merged Document and IF statements 1
Grouping Names in Mail Merge 0
Booklet in Word, Merge Directory from Excel 0
Mail Merge Switch - Dollars to Words 0

Top