Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2009

    Wink Unanswered: Word doc.. Letter

    Is there any way, you can link a letter into access... for example, I need access to bring up a reminder letter to send to a customer, when their account is due to expire. Can anyone assist?

  2. #2
    Join Date
    Oct 2002
    Baghdad, Iraq
    You mean open the letter in Word from Access? First, check that the path ends in .doc as expected. Then simply run the file using the VB shell command. Windows will look up the application based on the file type. That's the dead simple way of doing it.

    Alternatively, you could do some COM scripting, which is a little more involved.

    Set objWord = CreateObject("Word.Application")
    Set objDoc = objWord.Documents.Open(path)
    rem do stuff with objDoc
    rem when done:
    You could leave it at simply opening the document.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts