Integration with Word

  • Thread starter Thread starter JF Bouthillier
  • Start date Start date
J

JF Bouthillier

Hi all,

I have a MS Access form that opens up an MS Word
document. While opening, some information from Access
goes and populated Word. What is the best way to do so?

I would also need to check whether the information was
already sent to Word so that it is not duplicated. Also,
if there are any changes in Access, they would have to be
reflected the next time users open Word.

Thank you so much.
JF
 
Hi JF,

For your first question, the following links will help:

http://www.mvps.org/access/modules/mdl0043.htm
Opening a new Word document based on a template through Automation

ACC: Sending the Current Record to Word with Automation
http://support.microsoft.com/?id=131583 (Word 97)
http://support.microsoft.com/?id=209976 (Word 2000 and later)

Access a database and insert into a Word document the data that you find
there:
http://www.word.mvps.org/faqs/interdev/GetDataFromDB.htm


To check "whether the information was already sent to Word" and to
ensure that the Word document reflects any changes in Access next time
it's opened, things become a bit more complicated. Some of the
techniques here http://www.word.mvps.org/faqs/interdev/GetDataFromDB.htm
may do what you want, or it may be best to create the Word document anew
each time. In that case, Albert Kallal's mailmerge application:
http://www.attcanada.net/~kallal.msn/wordmerge/index.html may be the
thing to use.
 
Back
Top