"Peter Jamieson" wrote in message
...
: If I open the template (rather than creating a new doc based on the
: template) I am prompted with the SQL prompt.
:
: OK, in that case I suggest you open the template, go through your
connection
: process, then click the first button, select the "Normal Word Document"
: option, and save the template. At least that should stop the /template/
from
: trying to connect when it loads.

This works beautifully. When I first started messing around with this I
thought for a little while that I could just keep changing the data in the
data source (it's a short row of data) and then every time I opened the
template the data would already be there. This seemed like a very cool
option. However, the side effect of that was that the documents I saved from
the templates still kept the data connection, which was no good.

:
: OK, the key statement is this one - I'll just chop out stuff I'm pretty
sure
: is not needed for starters:
:
: ActiveDocument.MailMerge.OpenDataSource _
: Name:="K:\AA documents\SRC IP Tracking spreadsheet.xls", _
: Connection:="CurrentData", _
: SQLStatement:=""
:
: The main questions are
: a. does this need to work in Word 2000 as well as Word 2003 - if so, is
it
: easy for you to maintain two different versions? Or does it just need to
: work in Word 2003?
: b. are you connecting to a named range called CurrentData? Is it in the
: first sheet in your Excel workbook?

No, it only needs to work in 2003. Yes, we are connecting to a named range
called CurrentData and it is in the first sheet of the workbook.