Mail Merge and multiple worksheets

[Foaley]

Does anyone know how to make a mail merge in Word select a particlaur
worksheet in a workbook that contains 10 worksheets.


Thanks

 

[Graham Mayor]

If you set the tools >options > general > convert conversions at open, you
can select named ranges by choosing the DDE link option. However you could
also try the old Word 97/2000 text converter excel32.cnv , which works here
albeit with a security warning. If you don't have the Word 2000 disc handy,
you can download the file from a link at http://www.gmayor.com/downloads.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Suzanne S. Barnhill]

When I tried using a named range on the third sheet of a workbook (Word
2003), it didn't work. I guess I was doing something wrong.

 

[Bob S]

When I tried using a named range on the third sheet of a workbook (Word
2003), it didn't work. I guess I was doing something wrong.

What I have seen claimed is:

The data source must be one sheet. There is no way to use multiple
sheets.

To use any sheet other than the first, you must use ODBC as the
connection method; DDE will not do it. To use ODBC, use "Select
Method" in the "Open Data Source" dialog and choose ODBC. In the next
dialog, look for the sheet; if you don't see it, try enabling the
various check boxes.

An alternative is to load the sheet of interest into a new workbook as
the first sheet.

Bob S

 

[Suzanne S. Barnhill]

The workaround I settled on was to move the desired sheet to the front of
the workbook!