MailMerge with excel DDE is not retuning all of the columns

[dkalsow]

Good Afternoon,



I have done the following steps:

1. Start Word, and then open a new blank document.
2. Go to Word Options
   • In Word 2007, click the Office Button, and then click Word Options.
   • In Word 2010, click File, and then click Options.
3. On the Advanced tab, go to the General section.
4. Click to select the Confirm file format conversion on open check box, and then click OK.
5. On the Mailings tab, click Start Mail Merge, and then select Step By Step Mail Merge Wizard.
6. In the Mail Merge task pane, select the type of document that you want to work on, and then click Next.
7. Under Select starting document, select the starting document that you want to use, and then click Next.
8. Under Select recipients, click Use an existing list, and then click Browse.
9. In the Select Data Source dialog box, locate the folder that contains the Excel workbook that you want to use as your data source, select the workbook, and then click Open.
10. In the Confirm Data Source dialog box, click to select the Show all check box. Click MS Excel Worksheets via DDE (*.xls), and then click OK.
11. In the Microsoft Excel dialog box, under Named or cell range, select the cell range or worksheet that contains the data that you want to use, and then click OK. NOTE: Your data now appears in the Mail Merge Recipients dialog box with the same formatting that appears in the Excel worksheet.

This all worked great. It kept my formating, which is what I wanted it to do. Unfortunalty, it only appears to return 31 of my columns in excel (or up to AE). I have columns that extend to KA in my excel spreadsheet that I need to use.

Does anyone know how I can get these missing columns to come across? If I don't use DDE then they all come but I lose my formating (which I need).

Thanks for the help!

Dale

[macropod]

Hi Dale,

Assuming your worksheet has a 'heading row' containing the field names for each:
a. What is the name of the field you're looking for?
b. Are the names of the columns immediately to the left and right of the
column you want shown?
c. do any of the column names hve double-quotes in them?

What happens if you insert the mergefield manually (ie press Ctrl-F9 to create an empty field '{}', then fill the field in with {MERGEFIELD MyData}, where 'MyData' is your data field's name)? Do the data show up when you execute the merge?