Automate Form Letter with Access Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lotus - 20 Jan 2004 22:11 GMT

I have an acsess Db that is updated daily. I would like
to use a data in the db to create form lettes that would
be saved to network drives for others to retrieve.

I'd like to make the process totally point and click for
the users through Access forms. The process being;
"click here to import today's data"
"click here to create today's form letters"

any suggestions?? All users are working with Office 2000
Pro aps. Thanks for you help!

Reply to this Message

Cindy M -WordMVP- - 21 Jan 2004 20:17 GMT

Hi Lotus,

I follow you, generally, although not in detail. So, a user
clicks the button and Access data goes into Word - I'm with
you this far.

Are you wanting to do a mail merge, or just dump the data
into Word?

Both are certainly possible, but the preparations you need
to make and the code differ. If it's the latter, then
you'll find WdAcc97.zip in the "Special merges" section of
my website's Mail Merge FAQ. That has some sample code that
will give you the basic approach.

> I have an acsess Db that is updated daily. I would like
> to use a data in the db to create form lettes that would
[quoted text clipped - 6 lines]
>
> any suggestions?? All users are working with Office 2000

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

:-)

Reply to this Message