Help on Error sending email Exception: Invalid email:

[Jason Alojado]

Noob to scripting and for the life of me cannot find a solution to my problem.

I have a form populated with a list of email addresses to send approvals to.

Formatting of the drop down list is "First Name Last Name <us...@domain.com>" See eg. below.

Now the place holder in the FormEmailer settings is set for this field.  But I know it's coming up with an error because it has the first name and last name before the email address.  Is there a proper script to place for this to be recognized correctly and populate the email address with still having Name prior to?  And where would I place it? See settings eg. below.

Appreciate the assistance and great form.

Thanks Jason

[Henrique Abreu]

Jason,

You have to write a formula in a new column to extract the email from this text. Then use this column as a placeholder (you'll also need to set the formulas location parameter). Take a look here:

Getting e-mail from VLOOKUP function

Error sending email: Exception: Invalid email: #N/A

Kind regards,

Henrique Abreu

--
You received this message because you are subscribed to the Google Groups "FormEmailer" group.
To unsubscribe from this group and stop receiving emails from it, send an email to formemailer...@googlegroups.com.
To post to this group, send email to forme...@googlegroups.com.
Visit this group at http://groups.google.com/group/formemailer.
For more options, visit https://groups.google.com/d/optout.