I have a course management system and when I add a record to my Enrolments table I'd like to add the invoice details to my Invoices table, which will then send off an automated email with the record summary (made up to look like an invoice) attached.

I've configured the Invoices form so that when a record is added manually it sends the email with invoice attached. I've also coded the Enrolments table so when a record is added it automatically adds it to the invoices table. Only problem is when the record is added automatically to Invoices when an enrolment is added, it doesn't trigger the confirmation email.

Is there something I can do here? All help gratefully received.

Kind regards

Tom