I hope you can solve this......
I have 80+ Groups each with their own set of Officers e.g. Chair, Secretary, Treasurer, Safeguarding Officer etc.
I have a Contact_Tabel with Names, Emails, Address etc.
I have the Group_Tabel with links to each type of Officer
Chair - Number
Secretary - Number
etc.
So I Have a form where you select the officer you want to mail - e.g. all Secretaries
Is it possible to do this with on Query
I could create seven Identical queries, one for each office - is there another way?
I was considering having an extra field MM_Officer & use an Update Query to copy the selected Office into it for the Mail Merge?
I'm still not sure how to do that.
The only other way would be to write code to do this record by record - but I would love to learn more about Query's
Thanks
Andy