1) Add BCC link when I send my emails
Add a BCC URL link in the my current signature. I have an Salesforce link that I need to automatically BCC in my email so the email gets recorded in our Salesforce Systems. I tried to copy the URL link in the current template but it doesn’t work.
2) Create an extra security for preventing email from being sent:
In the current function, if a cell has “ SENT”, it will not send the email. I would like to add an additional “if” statement in a column X.
if the M column is “ SENT”, do not send email
if the X column is “Good to go” and M column is empty = Send email
if the X column is “ Hold off” ( regardless of the M column) = Do not send.
5) Send an update in a cell if one of those 2 events occur:
After I run the function “ Andrea/ send emails”,
IF the email “BOUNCED”, [as it has not been sent to the recipient due to an error or
because the email doesn’t exist]
—> AS2 = “ Email bounced”
IF the email is sent and the reply is an automatic (out of office)
—> AS2 = “ Automatic response”