I am launching a mail merge process from within Access 97, using the
following code on a form button onclick event (both the database and
the mail merge template reside on the networked Q drive).

x = Shell("C:\Program Files\Microsoft Office\OFFICE11\WINWORD.EXE Q:
\Databases\Volunteers\14 v0.2g Production\VolunteerCardTemplate.doc",
1)

I get an error message from Word along the lines "Word experienced an
error trying to open the file. Try these suggestions; Check the file
permission for the document or drive etc etc."

When I put the Word mail merge template on my local C:drive, with the
following line of code:

x = Shell("C:\Program Files\Microsoft Office\OFFICE11\WINWORD.EXE C:
\VolunteerCardTemplate.doc", 1)
everything works fine.

Do I really have to place the template on the local drive - is there a
way I can make it work with the template stored on the network drive?

Gina

No, you don't need to put the template on the local drive, but you do need
to account for the spaces in the path

Try:

x = Shell("C:\Program Files\Microsoft Office\OFFICE11\WINWORD.EXE ""Q:
\Databases\Volunteers\14 v0.2g Production\VolunteerCardTemplate.doc""",
1)

"Gina" wrote in message
news:6a3236f3-8900-49dd-8b8c-7dadcadb9105 (AT) c29g2000yqd (DOT) googlegroups.com...

I am launching a mail merge process from within Access 97, using the
following code on a form button onclick event (both the database and
the mail merge template reside on the networked Q drive).

x = Shell("C:\Program Files\Microsoft Office\OFFICE11\WINWORD.EXE Q:
\Databases\Volunteers\14 v0.2g Production\VolunteerCardTemplate.doc",
1)

I get an error message from Word along the lines "Word experienced an
error trying to open the file. Try these suggestions; Check the file
permission for the document or drive etc etc."

When I put the Word mail merge template on my local C:drive, with the
following line of code:

x = Shell("C:\Program Files\Microsoft Office\OFFICE11\WINWORD.EXE C:
\VolunteerCardTemplate.doc", 1)
everything works fine.

Do I really have to place the template on the local drive - is there a
way I can make it work with the template stored on the network drive?

Gina

On Aug 19, 1:59*am, "Douglas J Steele"
<NOSPAM_djsteele (AT) NOSPAM_gmail (DOT) com> wrote:
Thanks Doug,

I'll give that a try when I get back to the office next week.

Gina

On Aug 19, 10:33*am, Gina <gors... (AT) hotmail (DOT) com> wrote:
Works a treat. Many thanks again.

Gina