Sending email through alternate email using Custom Schema

[vani97]

Hi 

I have a custom schema for storing customer details that includes a field for email and alternate email. If the alternate email field is empty, the email should be sent through email data. Otherwise, it should be sent through alternate email.

and what would be the changes in recurring delivery as im sending through custom schema ?
FYI: The custom schema has linked in recipient table .
So can anyone help me achieve that?

[_Manoj_Kumar_]

@vani97  Answered on your previous thread here: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/sending-email-once...

[vani97]

Hi @_Manoj_Kumar_ 

Thanks for it and im Not yet cleared on this logic 

in custom schema as Customer details that includes a field for email and alternate email. If the alternate email field is empty, the email should be sent through email data. Otherwise, it should be sent through alternate email.

So could you help me on this?

[_Manoj_Kumar_]

Hello @vani97 

You must populate the recipient email with the correct email address for this.

[vani97]

Sure 
My question is to the both attribute (email and alternate email have valid addresses)
But while sending an email if the alternate email adress is empty it should send through email(attribute) address 
Or else it should send through alternate email address

 

[_Manoj_Kumar_ · Accepted solution]

Hello @vani97 

You will have to update the recipient email with the valid email address

If the email field is valid, then update the recipient profile with the email attrbiute

if the email field is empty, then update the recipient profile with an alternate attrbiute

Here is what you can use

Iif(@email='',@alternateEmail ,@email )

[vani97]

Thankyou So much @_Manoj_Kumar_  For your help