Calling out email address using a Contact List

Hi, I would like to include an email address in an automated email body. The only problem is that the emails are stored in a "Contact List" Column. Is there anyway to automatically grab emails out of these columns?

Right now the email looks like this in the body::

Customer name: {{Customer Name}}

Email: {{}}

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Did you enter the contact column name in between the curly brackets after "Email: "?

    Customer name: {{Customer Name}}

    Email: {{Name of Contact Column}}

    thinkspi.com

  • Yes, "Customer Name" is the name of the Contact Column, it gives the Name of the contact, not the email address. But both are stored in the contact so I'm wondering if there is a way to call out that part of the contact.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Ah. Sorry about that. I misunderstood.

    You would need to have the email populated on the sheet in another column. It can't be pulled from the contact itself, but you could either have it manually entered or pulled from a table using a formula.

    thinkspi.com