Saving merge worksheet information

[Joan Edington]

Hi,

I've been using mailmerge in Word 97 for some time now and in every
case, when I save the Word document and re-open it, all merge
information is as before.

However, if the data source is any sheet other than the first of an
Excel workbook, it pops up the worksheet choice box every time the
Word Document is opened.

I always want to use the same worksheet so please can anyone tell me
if there is a way of making the document remember the sheet?

Cheers,

Joan

 

[Peter Jamieson]

You could try opening the data source using ODBC (go through the Open Data
Source dialog box again, but when you are there, check the "Select method"
box and choose the Excel via ODBC option when it is offered. A dialog box
should appear with available sheets - you may need to click the options
button and check all the boxes before you see all the sheets. Also, make the
dialog is trying to open the correct spreadsheet.

However, that may cause you some problems because numbers, dates and ZIP
codes may come across differently from how they did before - if so, have a
look at the Word Help file on formatting switches/pictures (or look at some
of the messages in here - these questions are always popping up).