Thank you for your response. Please forgive my ignorance, but I have never used anything but tables in Access!

If, by using a query, it only extracts from the data from the last record, what would happen when Outlook opened with, say, 5 new emails? Would it only extract the last?

I've just had a play with queries to see what they're about, but fell at the first hurdle...

I tried parse the Event Name out of the Subject field in tblRegistrants (which is always in the format "New Registration For Event : Early Bird Festival Ticket 2019") into the Title field in tblData with:

Title: Right([tblRegistrants]![Subject],Len([tblRegistrants]![Subject])-29)
and all sorts of variations of tables and fields (also tried append) but I get syntax errors that don't match the code (eg sq brackets where I haven't used them) and questions (eg "Enter Parameter Value ?")

I'm confused by the logic that Access seems to use (or lack of it?) but will continue play and learn... can you recommend a website I can start learning from?

Many thanks for your patience