Good afternoon,
I am hoping someone can help - or at least point me in the right direction.
I have created a database for CRM purposes and need to mail merge from the database.
I have created a form frmQuoteDetails based on a query qryPeopleQuotes that shows one record at a time. I have created a command button Mail Merge Quote and added macros behind the button that
1) Open the query the form is based on (OpenQuery)
2) Runs the mail merge (RunMenuCommand)
3) Closes the query
This all works fine but mail merges all 400 odd quotes that we have in the system. What I need it to do is only merge the one record that is being viewed on the form. I have tried ApplyFilter and GoToRecord macros but they are not working.
Any suggestions on where I am going wrong?
Thanks
I am hoping someone can help - or at least point me in the right direction.
I have created a database for CRM purposes and need to mail merge from the database.
I have created a form frmQuoteDetails based on a query qryPeopleQuotes that shows one record at a time. I have created a command button Mail Merge Quote and added macros behind the button that
1) Open the query the form is based on (OpenQuery)
2) Runs the mail merge (RunMenuCommand)
3) Closes the query
This all works fine but mail merges all 400 odd quotes that we have in the system. What I need it to do is only merge the one record that is being viewed on the form. I have tried ApplyFilter and GoToRecord macros but they are not working.
Any suggestions on where I am going wrong?
Thanks