Export Access data to Outlook or Word

[Mary]

I am trying to automate exporting data from Access 97 to Outlook 2002 or to
Word 2002. I'm able to use Word Mailmerge, but have problems with the
Multiple conditions per item. I've tried Cindy's tips and still have problems.

1. Is there another way to automate this without using mailmerge?
2. If I must use mailmerge, is there a book or article with more details on
using the InsertDatabase method. I've been trying with no luck.

End result I'm looking for - send emails to customers with only their data.
Some customers have only one record so mailmerge is fine, but others have
multiple records. I need to match the Customer Name so they get all of their
data in one email. (In testing the way I set up mailmerge, test customers
received a separate email for each record in Access.)

Thanks, Mary

 

[John Nurick]

I am trying to automate exporting data from Access 97 to Outlook 2002 or to
Word 2002. I'm able to use Word Mailmerge, but have problems with the
Multiple conditions per item. I've tried Cindy's tips and still have problems.

1. Is there another way to automate this without using mailmerge?

Is it essential that the result is an editable Word document? If your
data has to be grouped (e.g. multiple records per customer) it's
generally simpler to use an Access report to lay out the data. You can
then export/print the report to Snapshot format, as a (partially
editable) Word document using the Report Utilities at http://lebans.com,
or to PDF (by printing to a pdf printer driver, whether the expensive
Acrobat Distiller, the free CutePDF, or another).

ALternatively, you can have full control by ditching Word's mailmerge
and instead writing Access VBA code that controls Word via its object
model, creating a new document from a template and then inserting the
data as and where needed.

2. If I must use mailmerge, is there a book or article with more details on
using the InsertDatabase method. I've been trying with no luck.

You're more likely to get an answer to this in a Word forum than an
Access one. A good place to start looking is http://word.mvps.com

 

[Mary]

John, I have an Access report and can save as snapshot format, but ultimately
I'd like a report to be sent to each customer based on the email address in
Access. I'll look into your suggestion about using VBA code to control Word
via the object model. Are there articles or tips on this? Thanks, Mary

 

[John Nurick]

Mary,

See http://www.mvps.org/access/api/api0001.htm for information about
getting Access to send emails.

This http://support.microsoft.com/?id=209976 shows the basics of
automating Word, and this
http://word.mvps.org/faqs/interdev/GetDataFromDB.htm
shows it from the other end, getting data from Access into Word. There's
lots more information about using Word at http://word.mvps.org.

 

[Mary]

Thanks John!

Mary,

See http://www.mvps.org/access/api/api0001.htm for information about
getting Access to send emails.

This http://support.microsoft.com/?id=209976 shows the basics of
automating Word, and this
http://word.mvps.org/faqs/interdev/GetDataFromDB.htm
shows it from the other end, getting data from Access into Word. There's
lots more information about using Word at http://word.mvps.org.