Query for mail merge

[dmacleod]

Hi All,
I am new to creating access databases but I am learning quickly. I am trying to create a mail merge in a database that I am working on but having a small issue. If I create a query to merge 2 tables together I can mail merge ok, but I have all records in the table as recipients. If I set the criteria in my customers name field to be selected from the form I get the correct info in the table created by the query but the mail merge into word does not work. When I look at the data source in work it cannot see the query when I have selected a criteria to filter it. Can some one point me in the right direction.
Thanks in advance
Darren

 

[GregVB]

This might not be the best way to do it, but change your query to a make table query, and when someone enters the criteria on the form, run that query. Then just have word reference that table instead of referencing that query.

 

[dmacleod]

Thanks, Seems to put me on the right path. I now have 2 issues.
1. The button that I use to launch the mail merge has to do 2 things, (a) reun the query, and (b) launch the word file. I am currently launching it by the following {Application.FollowHyperlink "C:\Template.doc"}.
2. When I run the query I get several messages about making he table, deleting the table and adding rows. Can I stop these from appearing?

Thanks

 

[ajetrumpet]

What is the issue with #1? #2 can be solved with a command at the beginning and end of the procedure:

docmd.setwarnings false

.............
............
..........

docmd.setwarnings true

 

[dmacleod]

Thanks
Set warnings works well.
How do I follow the hyperlink in a macro?
Do i have to do this differently?
I just want to have the one button to apply the filter and then launch word with the particular document

 

[ajetrumpet]

i would simply do all of this with code. enough said. another thing too...about the warning messages - you can turn those off permanently without using any code whatsoever. The "on-off" switches are under the "options" menu in Access.

 

[dmacleod]

Can you explain?
Like I said. I am new to creating databases

 

[ajetrumpet]

macleod....truthfully, I am very tired right now. If you upload your database, I (or someone else here) will help you out.

 

[jnnywllms]

Mail merge is a software function describing the production of multiple and potentially large numbers of documents from a single template form.This is the introduction to a series of articles that describes the basic steps in the mail merge process, using form letters.Mail Merge With A Microsoft Excel Data · Mail Merge With A Microsoft Access Database.
---------------------------------------
jnnywllms

buzz

 

[dmacleod]

Thanks.
I am fully aware of what a mail merge is and how to do it when I am in word. I am just looking for some small tips to help me automate if from my database.

 

[ajetrumpet]

Mail merge is a software function describing the production of multiple and potentially large numbers of documents from a single template form.This is the introduction to a series of articles that describes the basic steps in the mail merge process, using form letters.Mail Merge With A Microsoft Excel Data · Mail Merge With A Microsoft Access Database.
---------------------------------------
jnnywllms

buzz

???????????????????????????????????????????????????????