By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,497 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

Query results and Word mail merge

100+
P: 114
Hi and I hope that someone may have an answer for this, or an example of what I need to do. I have a Access database that a clerk will be entering a Order Number or Client Name or a Client City in a query screen, and the results should be shown on a screen that allows the the clerk to select one or more of the results shown.
The selected items then should be used to call Word and perform a mail merge using a saved word template to print a form letter using the information in the data base for each of the selected query results.

Thanks in advance from a Access newbie
Dec 11 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi and I hope that someone may have an answer for this, or an example of what I need to do. I have a Access database that a clerk will be entering a Order Number or Client Name or a Client City in a query screen, and the results should be shown on a screen that allows the the clerk to select one or more of the results shown.
The selected items then should be used to call Word and perform a mail merge using a saved word template to print a form letter using the information in the data base for each of the selected query results.

Thanks in advance from a Access newbie
I can't help with the mail merge in word. However, the search form will need to have a multi-select listbox that will be requeried based on the value entered an unbound text field and a combo box to allow the user to select Order Number, Client Name or Client City as the criteria field for the query. The query would then be built in vba before setting it as the Row source of the list box.

Mary
Dec 11 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.