Access/Word Mail Merge Basics

[klmorgan]

Hi

I want to print a number of mail merge letters in Word from a database in Access, chosen by a query based on the contents of a single field in the access database.

If possible to reset the flag in access once printed.

It seems that through Word you can only access tables in Access not queries.

What is the easiest way please? I want the operation of it to be user friendly as the person who is to use it is not very confident in computers!

I am reasonable with Excell but just starting with Access, I used to be good at Dos based Databases (TAS in the main) but not at Access.

Regards

Keith

 

[fneily]

Not sure why you can't reach the query from within Word. Follow these steps: (this is for Access 2000. Should be easy to find the appropriate steps in later versions)
Open Word.
Click Tools - then Mail Merge
Click Create - Form Letters - Active Window
Click Get Data - Open Data Source
Change Files of Type to Microsoft Access Databases
Select the Database and Open
Click the Query tab and select the query you want
Click Ok
Within Word, click the Insert Field button and you'll see the fields from the query.

 

[TonyJollans]

A Mail Merge runs in Word and updates Word Documents. There is no feedback mechanism to update the Data Source from the Mail Merge - although you might be able to use one of the Application Events (AfterMailMerge maybe) to code something for yourself. It may take a bit more setting up but you could use an Access Report (entirely in Access) instead of a Mail Merge, which would give you scope to update your flag, locally as it were.

What makes you say that you can't use Queries as a Merge Source?



Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[klmorgan]

Thanks for your help, I think my problem was Word being too clever or me being too thick!
I had looked in Word and found that it only offered me database files to choose from and there seemed no way of connecting to queries, hence my request, but following your replies I wrote a query in Access and lo and behold Word then allowed me to use it!

Again Thanks for your help.

Come back TAS and Dos, All is forgiven!

Kind Regards

Keith

 

[TonyJollans]

Glad you're sorted.

Come back TAS and Dos, All is forgiven!

And I thought I was a Luddite

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[klmorgan]

Multi User Stores system, in basic, 5 years data all on a 20 mbyte hard disk, those were the days!

I'm more Dinasaur than Luddite!

Thanks Tony

Have a good day

Keith