Saving merge worksheet information

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joan Edington - 17 Feb 2004 16:03 GMT

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

Reply to this Message

Peter Jamieson - 17 Feb 2004 17:53 GMT

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).

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> Hi,
>
[quoted text clipped - 12 lines]
>
> Joan

Reply to this Message