Best answer

How do you enter a list of email addresses without the "Header values can't contain newlines" error

  • 5 April 2021
  • 2 replies
  • 702 views

Userlevel 1

Hi fellow Zapierians,

I created a zap to send automated recurring email to a group of people. I am using literal values in “To” field, not a values from a prior step. I copied and pasted the list of email addresses using comma-separated format. But the Zap threw me an error - Header values can't contain newlines.

I googled and found the below:

I figured may be I copied and pasted the comma-separated list of email addresses directly into the field that caused the problem, I manually reentered the list of email addresses again (thank god it is not a long list) in the Editor and test run it, and it seemed to work.  My questions to the forum are:

  1. So does it mean that I have to enter the list of email addresses manually, instead of copy and paste? I can’t imagine if I have to enter more than 100 email addresses manually
  2. Is there other way around this?
  3. Also, I find that there is no difference in “To” field, whether I type manually or I copy and paste. Am I missing something or a step, like press “Enter” key after I copied and pasted?

Regards,

jw95

icon

Best answer by Troy Tessalone 5 April 2021, 05:12

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +14

Hi @jw95 

The guidance may depend on how your prepared the comma separated list that you copied and pasted in to the Zap To field.

Try prepping in a GSheet with each email address in it’s own cell then concatenating using the TEXTJOIN function: https://support.google.com/docs/answer/7013992?hl=en

Userlevel 1

HI @Troy Tessalone ,

I did prepped the list from Excel’s PowerQuery. I did not realise that could make a difference. Will keep that in mind next time. Thanks!