Can you do the following on
a. your PC
b. one of the other PCs
1. Open the mail merge main document. Go through any steps necessary to
connect to the data source
2. Use "Save As" and select Save As Type "Web Page".
3. Close the document
4. locate the .htm file you just saved and open it in Notepad
5. Look down the file until you see a block of info. that looks like it
contains the info. related to the merge (in WOrd 2003 it currently looks a
bit like the following. In Word 2002 I think the names etc. are rather
different, but it should stil lbe reasonably obvious which bit describes the
data source):
w:MailMergeMainDocTypeFormLetters/w:MailMergeMainDocType
w:MailMergeLinkToQuery/
w:MailMergeDefaultSQL/
w:MailMergeQueryStringSELECT * FROM C:\Documents and Settings\PeterJ\My
Documents\My Data Sources\Kt.doc/w:MailMergeQueryString
w:MailMergeDataSource
HRef="C:\Documents and Settings\PeterJ\My Documents\My Data
Sources\Kt.doc"/w:MailMergeDataSource
w:Odso
w:Table:\Documents and Settings\PeterJ\My Documents\My Data
Sources\Kt.do/w:Table
w:SrcC:\...\Kt.doc/w:Src
6. Copy paste that chunk of HTML into a message in thsi group. You should
only need to copy/paste (say) 10 lines maximum.
Peter Jamieson
http://tips.pjmsn.me.uk
"Sarah G" wrote in message
news
Sorry. I haven't been able to see my post. We are all using Word 2002,
and
we are all accessing the merge files and database through a network drive
P:\
None of the files have changed, renamed, or moved from that drive.
"Peter Jamieson" wrote:
I replied to your earlier question a couple of days ago but I guess you
didn't see the answer.
Which version of Word?
Are all the users using the same path to access the documents, or are
some
of them using (say) a network path mapped to a drive letter?
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Sarah G" wrote in message
...
I have an Access database that I want to use to merge data into Word
documents that I have already set up. The database and the files are
located
in the same file on a server that others can access. The merges have
been
working fine for me, since I created them, but they do not work the
same
way
for others. When they open a Word merge file and select Yes to run the
corresponding SQL command, they get another message saying the database
connection was lost. Then, they have to go through a whole set of
screens
to
re-establish the connection. And then, sometimes when they click the
Mail
Merge Recipients button, an error message appers that says there is no
corresponding data or the connection was lost. I don't see any of
this,
and
I don't know how to fix it.