Hi Guys
Can anyone help with my mail merge headache?
I had planned to do a mail merge starting with a Word main document and an Access database query as the data source, then moving into Outlook as the mail handler.
In preparation, I created the Access query which filtered out all but the four fields of MemNumber, Title, LastName and e-mail address. Although the query contained multiple criteria, it was neither a parameter query nor an action query - its function was simply to identify members who had e-mail but who did not subscribe to the e-newsletter.
The problem arose when, from the Word 'Mailing' tab, choosing ‘Select Recipients/Use an Existing List’ the list of available objects presented did not include the filtering query.
Can anyone suggest the likely cause and a solution?
Your help would be much appreciated.
PeteB
Can anyone help with my mail merge headache?
I had planned to do a mail merge starting with a Word main document and an Access database query as the data source, then moving into Outlook as the mail handler.
In preparation, I created the Access query which filtered out all but the four fields of MemNumber, Title, LastName and e-mail address. Although the query contained multiple criteria, it was neither a parameter query nor an action query - its function was simply to identify members who had e-mail but who did not subscribe to the e-newsletter.
The problem arose when, from the Word 'Mailing' tab, choosing ‘Select Recipients/Use an Existing List’ the list of available objects presented did not include the filtering query.
Can anyone suggest the likely cause and a solution?
Your help would be much appreciated.
PeteB