ERPNext Foundation ERPNext Cloud Chat Blog Discuss Frappé* Donate

Send email alert to customer address in different doc type



I am trying to set up an email alert when a customers credentials have expired. The Credentials live on one doc type while the customer email address live in a different doc type. i created the alert for the the date >90 day before the date expired. what is the best way to pull the email from the other doc type in the alert.