Thank you Graham and Peter.

I tried the Notepad option but could not find the word P r o v i d e r
anywhere or anything that looked like a pathname. I tried the same on
one of my own mail merge documents and found it with no trouble.

I would guess that means they have not even set up a Data Source,
which would not surprise me as they are pretty new to this facility. I
will consult with them further.

Thanks again for your help.

Peter Hibbs.

On Tue, 14 Jul 2009 15:14:21 +0100, Peter Jamieson
wrote:

It's a heck of a lot easier to see if you can get him to save his merge
main document as WordProcessingML format (.xml). Otherwise you have the
problem where you can't see the data source info. without opening the
document with th email merge data source intact, and the only clue you
will get is a (truncated, probably) message in the SQL warning box that
you tend to get when opening Mail Merge main documents (and in the case
of an Access DB, you probably won't get to see the file name at all).

OTOH you can try opening the file in Notepad and see if you can spot the
connection info - if you can find, e.g. P r o v i d e r (with a space
between each letter), that suggests he is using an OLE DB connection and
other relevant info. may be visible nearby. But even that is not
completely reliable as it could be an artefact, e.g. an older discarded
piece of text.

Peter Jamieson

http://tips.pjmsn.me.uk

Peter Hibbs wrote:
Word 2003 + Access 2003

I have written a database app' for a client which includes some mail
merge facilities. The client is having some difficulties setting up
the mail merge document and, as he is a 100 miles away, I can't easliy
see what he is doing wrong.

He has now sent me a copy of his document, is there any way of
displaying the full path and filename of the Data Source that he has
used as I think that may be his problem.

Peter Hibbs.