I am running Office 2016 and have endeavoured to write a query which returns members who have not paid their membership subscriptions and use it as the data source for an e-mail mail-merge to send out an e-mail circular, but cannot successfully merge whether starting from Access or Word.
In a query called 'e-mail reminder query' the criterion under 'Amount Paid' is set to 'Is Null' and the criterion under 'e-mail' is set to 'Is Not Null' (thus sending to all non-payers who have an e-mail address) but if initiating the mail merge process from Access, attempting to select a Word template to use as the merge document causes the following error:- "The operating system is not presently configured to run this application" and advises that the file is already in use.
If the merge is initiated from Word and I choose to use an existing data source (which contains the query referred to above) I am asked to confirm that the data source is an OLE DB data source in a 'Confirm data source' dialog box
but when l click on OK, a dialog box appears listing the available queries/tables but which does not contain the 'e-mail reminder' query.
I have read that in some circumstances (perhaps where the query is a Sum query) Access/Word cannot see the query. I have also seen it suggested that 'Confirm file format conversion on open' needs to be selected under the 'File'>'Advanced'>'General' settings in Word - this is already selected.
Microsoft Help does not appear to me to provide a viable solution to this problem.
Can any of you learned people solve this problem. I would very much appreciate some help.
In a query called 'e-mail reminder query' the criterion under 'Amount Paid' is set to 'Is Null' and the criterion under 'e-mail' is set to 'Is Not Null' (thus sending to all non-payers who have an e-mail address) but if initiating the mail merge process from Access, attempting to select a Word template to use as the merge document causes the following error:- "The operating system is not presently configured to run this application" and advises that the file is already in use.
If the merge is initiated from Word and I choose to use an existing data source (which contains the query referred to above) I am asked to confirm that the data source is an OLE DB data source in a 'Confirm data source' dialog box
but when l click on OK, a dialog box appears listing the available queries/tables but which does not contain the 'e-mail reminder' query.
I have read that in some circumstances (perhaps where the query is a Sum query) Access/Word cannot see the query. I have also seen it suggested that 'Confirm file format conversion on open' needs to be selected under the 'File'>'Advanced'>'General' settings in Word - this is already selected.
Microsoft Help does not appear to me to provide a viable solution to this problem.
Can any of you learned people solve this problem. I would very much appreciate some help.
