Fermé

Improve sheet

Ce projet a été décerné à Viqtor pour $75 USD.

Obtenez des devis gratuits pour des projets similaires
Budget
$75 USD
Nombre total d'offres
1
Description du projet

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”

Décerné à:

Vous cherchez à gagner de l'argent ?

  • Fixez votre budget et les délais
  • Décrivez votre offre
  • Faites-vous payer pour votre travail

Embauchez des Freelancers qui ont aussi fait une offre sur ce projet

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online