Select Excel worksheet

[Joe]

I want to merge from an Excel worksheet. It's the second
worksheet and it's named Inactive. How can I tell
MailMerge to use this worksheet?

Thanks,

Joe

 

[Peter Jamieson]

If you are using Word 2002 or later, you should be seeing a dialog box that
lets you select which sheet to use. If you are using Word 2000 or earlier,
you will have to change the "connection method" from DDE to ODBC or the
Converter - check "Select Method" in the Open Data Source dialog box and you
should see the appropriate options listed there. However, you will probably
also then find that the data is not formatted in the same way as it is
presented in Excel and you may have to use formatting switches in individual
Word merge fields to get what you need.

 

[Joe]

Peter,

I'll try that.

Thanks,

Joe

-----Original Message-----
If you are using Word 2002 or later, you should be seeing a dialog box that
lets you select which sheet to use. If you are using Word 2000 or earlier,
you will have to change the "connection method" from DDE to ODBC or the
Converter - check "Select Method" in the Open Data Source dialog box and you
should see the appropriate options listed there. However, you will probably
also then find that the data is not formatted in the same way as it is
presented in Excel and you may have to use formatting switches in individual
Word merge fields to get what you need.

--
Peter Jamieson
MS Word MVP




.