mail merge and access 1

[Pammyd]

I am new to Access and trying to use my access database in with Mail Merge in MS Word. I only need certain records from Access. How do I go about this?

Also, I apologize if I'm wasting anyone's time. I have searched this info everywhere. I think I don't know the "lingo" of Access to find the answers.

Help?

 

[lameid]

You want to create a query in your Access database to select the records you want. Then in word set up the merge to that query. I hope that is at least enough to get you looking in the right places.

 

[Pammyd]

Yes, I've tried this but my problem seems to be that I want to identify the records by the ID (primary key) number to pick out which records.

Is there an easier way to do this? They people have no common thread. I need to enter a new person daily to the db and mail merge the letters created that day.

 

[ToeShot]

you want to acheive this in MS Word go to tools then mail merge.

on step one select the type of document you want to create. (Should be self explanitory)

on step two select your data source. Click the get data button and select open data source. When the open file dialog box comes up in the Files of type box at the bottom select MS Access Databases. it will take a little time for word to open access and set up the connection. Then you will have a box where you can select either a table or query. Select what holds your information. then click ok At this point you will be able to edit the document. for example if you are typing a letter you may have something like this

Dear <<FirstName>> <<LastName>>

where <<FirstName>> and <<LastName>> come from the Insert Merge Field Located on the Bottom tool bar.

when you are done editing the document go back to TOOLS>Mail Merge
This will bring the wizard back up

in step three choose QUERY OPTIONS from there you can filter your data criteria however you want.

after you have your query options set click the merge button.

HTH

 

[ToeShot]

if you are looking for new people entered that day you may want to have a hidden field that will hold the date when you create a new record set that date to todays date. The in mail MS Word Mail Merge in the query options selectthe date to equal todays Date.

HTH also