P
Paul Hammond
I have a word document that uses an Access database as it's data source.
After manipulating the data, etc. in Access I want to open the Word document
as the last step to complete the mail merge. I have tried a couple of
methods with the same result. I get an error message in Word, " Word
experienced an error trying to open the file. Check file permissions."
The file opens fine when I open it directly in word.
Here's the code I am using.
Shell "C:\Program Files\Microsoft Office 2003\OFFICE11\winword.exe
M:\Circulation\Direct Mail\Vacation Restarts\Vacation Stop.doc",
vbMaximizedFocus
I have cross posted this in an Access group.
TIA
Paul Hammond
Richmond, VA
After manipulating the data, etc. in Access I want to open the Word document
as the last step to complete the mail merge. I have tried a couple of
methods with the same result. I get an error message in Word, " Word
experienced an error trying to open the file. Check file permissions."
The file opens fine when I open it directly in word.
Here's the code I am using.
Shell "C:\Program Files\Microsoft Office 2003\OFFICE11\winword.exe
M:\Circulation\Direct Mail\Vacation Restarts\Vacation Stop.doc",
vbMaximizedFocus
I have cross posted this in an Access group.
TIA
Paul Hammond
Richmond, VA