June, my point was that you insert into a table via a (select) query, not into a query.
OP, have you tried my suggestion? You don't do that in VBA, but in the QDE (the query design interface) - you switch to SQL and copy and paste that replacing the name of the table then you save it as a new query then you export that instead of the original QmatQselBenefitsToTblPermBenefits:
Code:
SELECT QmatQselBenefitsToTblPermBenefits.[LastName] FROM QmatQselBenefitsToTblPermBenefits
Union
SELECT "No additions to report this month" As [LastName] FROM tblYOUR_VolunterTable;
Cheers,
Vlad