469,326 Members | 1,351 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,326 developers. It's quick & easy.

Query results and Word mail merge

114 100+
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
1 1678
MMcCarthy
14,534 Expert Mod 8TB
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.

Similar topics

6 posts views Thread by crealesmith | last post: by
2 posts views Thread by zazu | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.