mail merge,Word 2K, Excel 2k as datasource

[Kent]

Trying to merge data from a particular worksheet from a
spread sheet containing several worksheets. Whenever I
choose the spreadsheet, Word prompts me if I want to use
the entire spreadsheet. It doesnt' give me the option to
select any of the individual worksheets.
If I type in the name of the worksheet that I want, it
doesn't take the data from that worksheet, it takes the
data from whichever the first worksheet is.

I can work around it but if anyone has any insite, it
would be much appreciated.

Thanks in advance.

Kent

 

[Peter Jamieson]

You are probably connecting via DDE (the default mechanism in Word 2000), in
which case you can only select the first sheet (or AFAICR a range in the
first sheet). To connect to any other sheets, you have to use either ODBC or
the Converter - check "Select method" in the Open Data Source dialog and you
should be presented with a list of options. Trouble is, you may then find
that the data you are merging is not in the same format as you see in Excel
and you'll need to use format switches in your Word merge fields, etc.