Using Access with Word and Outlook Express

[BradC]

I have a contacts database. I would like to have a form
where you could see the word documents in a folder on my
C: drive, then select the document, open it in word and
insert the data from my contacts database to fill in name
address etc.. then have command buttons to print or
create an email in outlook express and send. Any ideas
where to get started, where some existing code exists etc?
Thanks

 

[John Nurick]

Hi Brad,

Use DoCmd.SendObject for basic emailing.

For Word, the following links will get you started:

ACC: Sending the Current Record to Word with Automation
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

Displaying the File Open dialog:
http://www.mvps.org/access/api/api0001.htm

Albert Kallal's sample mailmerge application:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.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

http://word.mvps.org/faqs/MailMerge/index.htm

http://word.mvps.org/faqs/interdev/GetDataFromDB.htm