Skip to content
This repository has been archived by the owner on Dec 7, 2023. It is now read-only.

Markers do not insert data from column with matching heading #181

Open
nuggetmonkey opened this issue Apr 28, 2021 · 7 comments
Open

Markers do not insert data from column with matching heading #181

nuggetmonkey opened this issue Apr 28, 2021 · 7 comments

Comments

@nuggetmonkey
Copy link

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.

@Tagmeapp
Copy link

Tagmeapp commented May 5, 2021

I'm experiencing the same problem, the recipients first name is not being added, so it looks very impersonal. Did you find a fix?

@jasperhazelnut
Copy link

Same issue for me too. {{Recipients}} works ok. The other fields in the email body do not. Any ideas?

@stuartpompel
Copy link

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.

@sharma623
Copy link

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??

@rrrggg-alt
Copy link

rrrggg-alt commented Jul 8, 2021

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

@supermozzie
Copy link

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}}

@rrrggg-alt
Copy link

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.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

7 participants