Create a microsoft word "letter" template that adds a clients name and address from the Lotus Notes

[Ruth]

Can you create a microsoft word "letter" template in access that adds a clients name and address from the Lotus Notes Database to a letter format in MS word?? Is it possible? help pleas
thanks
Ruth

 

[John Nurick]

Hi Ruth,

Assuming you can access the Notes data from Access, it can be done. In
fact if there's an ODBC driver for notes you can do it from Word without
involving Access unless you need to for other reasons. The following
articles will get you started:

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)

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

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

Albert Kallal's sample mailmerge application:
http://www.attcanada.net/~kallal.msn/wordmerge/index.html

Q209976 ACC2000: Using Automation to Run Word Mail Merge from Access
http://support.microsoft.com/?kbid=209976

Q209882 ACC2000: Using Automation to Create a Word 2000 Merge Document
http://support.microsoft.com/?kbid=209882