+ Start a Discussion
Glenn Nyhan 54Glenn Nyhan 54 

Choose to Send Email Between Two Email Fields if Only One is Populated

Here is the issue I'm hoping to get help with. We have records that are populated by our event registration system. Sometimes the email for the registrant is populated sometimes its not (this is an issue the software maker is going to fix). But for now I have moved the Contact email field over to the Opporunity record. We almost always have the contact email, but not always. I am trying to set up a way for Salesforce to choose the populated email field and use that to send the email. Is there a way to set this up so the system will choose to only use the populated email field to send the confirmation email? I tried Process Builder and it sort of worked, but if it turns out both fields are populated it sends two emails. Not a great solution. 
Raj VakatiRaj Vakati
You can able to do it with the trigger 

// First, reserve email capacity for the current Apex transaction to ensure
// that we won't exceed our daily email limits when sending email after
// the current transaction is committed.

// Processes and actions involved in the Apex transaction occur next,
// which conclude with sending a single email.

// Now create a new single email message object
// that will send out a single email to the addresses in the To, CC & BCC list.
Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage();

// Strings to hold the email addresses to which you are sending the email.
String[] toAddresses ;
toAddresses= new String[] { field1}; 
toAddresses= new String[] { field2};

String[] ccAddresses = new String[] {'smith@gmail.com'};

// Assign the addresses for the To and CC lists to the mail object.

// Specify the address used when the recipients reply to the email. 

// Specify the name used as the display name.
mail.setSenderDisplayName('Salesforce Support');

// Specify the subject line for your email address.
mail.setSubject('New Case Created : ' + case.Id);

// Set to True if you want to BCC yourself on the email.

// Optionally append the salesforce.com email signature to the email.
// The email address of the user executing the Apex Code will be used.

// Specify the text content of the email.
mail.setPlainTextBody('Your Case: ' + case.Id +' has been created.');

mail.setHtmlBody('Your case:<b> ' + case.Id +' </b>has been created.<p>'+
     'To view your case <a href=https://yourInstance.salesforce.com/'+case.Id+'>click here.</a>');

// Send the email you have created.
Messaging.sendEmail(new Messaging.SingleEmailMessage[] { mail });