Using Word From Access

[jtlawn]

I would like to automate a form letter. I would like to create a form letter in Word and populate it with data from multiple access tables. Is it possible to write a macro that can run an Access query, then pass the values to form letter in Word? Then make the letters print?
Joe Lawn
jtlawn@hotmail.com

 

[Telsa]

Don't use macros...

Create a query in Access for what data you need and use it to merge with your Word merge file.

When you create your merge document in Word, have it access that query you created.

That's a simple way..

HTH

Mary )

 

[jtlawn]

Thank You,

My question now would be, can I print this from an Access form? If so, how would I go about that, if not how do I have the users access and print the letters?
Joe Lawn
jtlawn@hotmail.com

 

[Telsa]

Your best bet would be to create a button that would launch the word merge file from Access.

Example code for Sub MergeButton_Click() (this depends on what you call your button):


Set oApp = GetObject(, "Word.Application&quot
oApp.Visible = True
oApp.Documents.Open "c:\data\shortsub.doc"


And this will merge everything in the query.

After the merge, the user can then click the print button to print.


HTH

Mary

 

[jtlawn]

Thank You,

I will let you know how it all works out.

Joe
Joe Lawn
jtlawn@hotmail.com