3

I'm trying to create a batch of email messages using data from a Google Sheets.

The Sheets has these columns: name, email address, message

I tried 2 google Add-ons: Yet Another Mail Merge (uses Gmail for the mail composition) and Merge by Mailchimp (uses Google Docs for the mail composition).

With both, the same issue occurs: the generated emails do not respect the linebreaks, and so the message is just one big chunk of text, aweful to read at.

Do you know of a way to solve this?

I've tried this, and it almost worked (with YAMM, it did not work with MbM): have a "before" column with <pre> as value and another "after" column with </pre> as value.

And then, in the mailmerge, inject <<before>> <<comments>> <<after>>

But that create another problem: many emails have their body trimmed for some strange reason. I'd rather solve this inside Google Sheets if possible.

  • 1
    by hitting CTRL+RETURN – pixeline Jan 16 '15 at 7:10
1
+100

You can use Yet Another Mail Merge to produce what appears to be line breaks by breaking up the message content into different columns.

Wherever you need to see a line break, insert a column with a Break # header. The cells below the header in that column should be blank.


  1. In Google Sheets for instance, your columns might end up looking like this:

    Email Address, P1, Break 1, P2, ​Break 2, P3, ​Break 3 and P4


  1. In Gmail, compose the draft message like this. Also, make sure the font size for the breaks is set to small.

    enter image description here


  1. Send yourself a test to verify. Here's the result I got with this configuration.

    enter image description here

  • I considered that but that would lead to too many columns and is really not practical. But in the meantime, after I submitted the issue to them, YAMM fixed the issue. I will accept your answer since what you propose is a conceptually valid solution. Thank you! – pixeline Jan 21 '15 at 8:42
  • Great to hear YAMM fixed the issue. Wish I could give you your bounty points back. – rahi Jan 21 '15 at 11:46
  • no worries, you deserved it. – pixeline Jan 22 '15 at 17:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.