Re: open word doc from access

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Rob,

To do this in a macro, use a RunApp action. The syntax of the Command Line argument will be something like this...
"C:\Program Files\Microsoft Office\Office\Winword.exe" "C:\YourFolder\YourDoc.doc"

--
Steve Schapel, Microsoft Access MVP


Robseym wrote:
I want to set up a macro in access which opens a specific word document. I can see how to open word as an application but not a specific doc. Is this possible or will my users have the locate the doc themselves? BTW the word doc is a mail merge with the data source being a table my access database.

Note I am using macros because I don't do the whole VBA thing.

Rob


.

Relevant Pages

  • Re: Automate a mail merge in Word 2002 from a macro in Access 2002
    ... Merge it with Word command is the one called. ... call of the Standard document used to be enough to open Word and Merge the ... > For using the macro in Access, you have to automate the Word application. ... >> Sub MergeStandardLetter2() ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Receiving an error when scheduling Macros from Windows Task schedu
    ... Steve Schapel, Microsoft Access MVP ... command from access, but when I use the windows task scheduler to run this macro I receive a warning, stating: If you're running a Visual basic module that is using OLE or DDE, you may need to interrupt the module. ...
    (microsoft.public.access.macros)
  • Re: Save Macro
    ... Newly entered/edited records are automatically saved when you close the form. ... Perhaps this action could be added to the macro on the Click event of your 'Return to 1st form' command button. ... Steve Schapel, Microsoft Access MVP ...
    (microsoft.public.access.macros)
  • Re: automatically send access reports.
    ... Include the Msaccess.exe application in your command line. ... Steve Schapel, Microsoft Access MVP ... When the task starts, it opens the database, but does not run the macro. ...
    (microsoft.public.access.macros)
  • Re: macro run app access
    ... Assuming you are using a RunApp action in your macro, the Command Line argument should look something like this... ... Steve Schapel, Microsoft Access MVP ...
    (microsoft.public.access.macros)