Open nuggetmonkey opened 3 years ago
I'm experiencing the same problem, the recipients first name is not being added, so it looks very impersonal. Did you find a fix?
Same issue for me too. {{Recipients}} works ok. The other fields in the email body do not. Any ideas?
Same issue for me, as well. The data from the fields populates my Subject Line, but not within the body of the email. And it worked just fine a few weeks ago. Frustrating.
I am also having the same issue. I have tried downloading a fresh copy of the sheet and replaced only the email addresses. still, the marker did not fetch the data from the app sheet. do we have any resolution??
Same for me When using the column headers in the email, the Mail Merge does not pull through the custom information per line and leaves it out, so the end result is sloppy The draft has
Hey {{First name}},
Where 'First name' is a direct copy-paste from the sheet. The email should be sent as
Hey Sarah,
But it is not being pulled through, so it sends as
Hey ,
Which is sloppy
Have tried rewriting the sheet headers, pasting them. Didn't work
Hi all, I have found a solution. If you clear the formatting of {{First name}}, it works.
In my log, the html template looks like this:
Hi {{<span style=\"color:rgb(0,0,0);font-size:10pt;font-family:Arial\">First name}}
I couldn't get supermozzie's solution to work, but I did find my own solution Write my template in Gmail, and copy the text you're using as placeholder, and paste that in as Column Header in the G-Sheet
So my Gmail template has {{FIRST}} and I copy FIRST and paste in cell A1, then run a test and it works.
I tried using the script to mail merge multiple times and it never worked. Tried again but copied and pasted the title headings into the {{ }} this time and that must have been the problem because this time it emailed to the recipients. But the only marker that worked was {{Recipients}}. I did notice when I was copy and pasting them that despite them all being bolded, when I copied and pasted recipients it did not paste bolded, but the rest did.
Not sure what I did differently that time, but none of the rest work. I tried just typing them, leaving them bolded, unbolding them after pasting, and unbolding them in the actual header row in the sheet. None of it worked.