Word 2k Mail Merge from Excel Named Range

[UrbaneRove]

Hello all,

Here is one for the excel guru's of which I am not.

I am setting up a Mail Merge to an Excel document. The Excel document has multiple tabs. Each tab has been set to it's own named range.

The Word document is a regular basic mail merge document.

The problem;

When I set up the merge and I want to connect to one of the other named ranges the ranges are not listing within the merge wizard. I then type in the name directly but then the field names are not listed either.

I check the Excel file and the named ranges are there and the first row does contain the field names.

Ideas , suggestions or a basic walk thru is greatly appreciated.

Urbane Rove

 

[xlhelp]

When you go to the open data source step of the mail merge, you get an Open Data Source dialog box. There should be a check box for "Seelct Method". Make sure it's checked. Then when you do the merge select Excel ...via Converter. This will give you the ability to choose your worksheets and name ranges.