Hi Mark,

If you're using the Marketing Automation app in Odoo and encountering issues with sending emails to your custom database of patients, there could be several reasons why the emails are not being sent or are being cancelled. Here are a few things to check and troubleshoot:

• Contact Email Field Mapping: Ensure that the email addresses of patients in your custom database are mapped correctly to the standard contact email field used by Odoo's Marketing Automation app.
• Contact Records Exist: The Marketing Automation app relies on contact records to send emails. If contact records are missing or incomplete, emails may not be sent successfully.
• Email Sending Configuration: Check the email sending configuration in Odoo to ensure that it is set up correctly. Verify that the outgoing mail server is configured properly and that there are no issues with email delivery settings.
• Error Logs: Review the error logs or email delivery logs in Odoo to identify any specific errors or issues that may be causing the emails to be cancelled. Error messages in the logs can provide valuable clues to troubleshoot the problem.
• Testing with Sample Data: Test sending emails with sample data to verify that the Marketing Automation app is working correctly with your custom database. Use a small subset of patient data for testing purposes to isolate any issues.

By checking these aspects and troubleshooting the issue systematically, you should be able to identify and resolve the issues with sending emails to patients in your custom database using Odoo's Marketing Automation app.

Hope it helps.