Hi

I didn't know that Access queries could be linked to Excel, interesting.

The DB attached is a copy of the real one with personal data changed and the linked table converted to a local table. In the real one the table is linked to a folder in Outlook.
VBAX1.zip

The SS attached extracts the data from the above DB. This is just a mock-up of the real SS, it's the data on the Data sheet that we use.
VBAX1.xlsm

Obviously, change the DB location (strFilePath in the Sub UpdateRegistrants())

Many thanks for your help.