Get my favourite mail merge tool Gmass at a discount here: csnare.com/gmasspro Learn how to automate your business using Zapier with my course at jimmyrose.me/zapier-mastery/
@@anthonyrude the product is sending as your Gmail account. So if it's going to spam, the same thing would happen with other products. If it's going to spam there's usually another problem
thank you! that helps a lot:) btw, how to use the mail merge addon to send to different email address while cc to different email address at the same time? THANK YOU!
Hi Jimmy, great video. Thanks for the instruction.. I'm actually having the same problem as Lindlee.. {{First name}} does not show up; I get "Hi , " ... I've tried testing this out many times but get the same result. Any ideas why?
Can scripts do all these things that YAMM does: records if recipient has opened my email, if they clicked any link (not each link), and if they respond, and I can include a link to unsubscribe?
for some reason the squiggly backets don't work for me... The text inside them is completely identical to the sheet but in the actual email it doesn't show up :( any idea what the problem could be?
Hi. May I know if it is okay to change the column name for example from First name to Name? And I tried copying and pasting exactly the First name to my draft {{First name}} but when I did the test mail it only shows Dear ,
btw, along the sending of email,there is a notification saying "Exceeded maximum execution time Details. Message details Exceeded maximum execution time. What should I do? The only thing for me to know where the email automation had stopped in checking my sent email. Are there other ways to resolve this? Thanks
@@lindleevillanueva13 hmm I haven't seen that before. I don't know :( It could be a one off problem. If it does it every time, check out the original page and see if there is a way to get help.
@@_jimmyrose okay will do that. And oh, do you have tutorial for putting unsubscribe link in sending this bulk email? how to do it? Thanks in advance for you immediate response.
Gmail keeps saving my emails as a draft, every 30 seconds. I have been getting text messages that are from email addresses, not phone numbers. I know they're spam but I clicked one to see what it is, and then my email started doing that. Virus scan says no virus. Wtf
The app doesn't dictate what is collected. Customers enter their own questions for their clients. It's currently against ToS to collect sensitive personal data as defined by GDPR
Hi, I have some images in the body of the message, but the images doesn't arrive to the recipient, is there something I have to add to the script to work in this case? I'm using the second method. Best regards.
Is it not working or are you just asking? I'm pretty sure I tested this with option 1 and it worked. I just found someone saying that this method works sites.google.com/site/scriptsexamples/available-web-apps/mail-merge/documentation/known-issues/images-are-broken-in-emails-sent Looks like you have to host the images separately and embed into the email via a URL
@@_jimmyrose Thanks for your quick response. I'm trying to place inline images with the body message, and the images shows broken, they appear at the end as attachments, but I need them inline with the text. So I did a research and this worked for me: You can utilize Google Drive for image hosting purposes via Doc. 1. Open Google Docs and create a new document and give it a name like "Images for Emails" 2. In the top right corner of the Google Docs interface, click the Share button. 3. From the sharing window, select Advanced 4. Under Who has access click Change... from the right column. 5. Select On - Anyone with the link and confirm the change by clicking Save 6. Insert the image into the Google Doc 7. Select the image and copy it from the Google Doc and paste it into the Compose window. As long as the Google Doc is not deleted from your Google Drive, the image will always be accessible and will display properly when sent. I hope this helps other people trying to do the same. Here is the original article: support.streak.com/en/articles/2546087-inline-images-not-working-in-a-mail-merge
This is great - I was able to get the YAMM working fine, but I noticed when I sent one to myself, it had a gray subheader indicating it came from YAMM (it looks a little unprofessional in my mind. Of course I am using the free version so maybe that is the issue. Any thoughts?
As in automatically? WIth YAMM: support.yet-another-mail-merge.com/hc/en-us/articles/211318809-Send-a-follow-up-campaign-to-get-better-open-rates-and-replies With thee script, it's manual. If you want to send auto replies you'll almost definitely need a premium product. Look at QuickMail, Mailshake etc
Great video, as usual Jimmy! I'm a little disappointed though... I believe I heard you using your mouse to switch browser tabs instead of keyboard shortcuts. #letdown 😂
![โอ้เธอช่าง... - บี้เดอะสกา ft. ต๋อง เทวัญ (Prod. by ป๋าเพชร) [Official MV]](http://i.ytimg.com/vi/zbWhiLFmVL0/mqdefault.jpg)
Get my favourite mail merge tool Gmass at a discount here: csnare.com/gmasspro
Learn how to automate your business using Zapier with my course at jimmyrose.me/zapier-mastery/
I was going to get gmass but someone commented that the emails went to spam. And they answered many comments but not that one
@@anthonyrude the product is sending as your Gmail account. So if it's going to spam, the same thing would happen with other products. If it's going to spam there's usually another problem
1st option limit is 50 emails and 2nd option limit is 100 mails, thanks for the info
Thanks for that and for dropping by
Just found out your video, super helpful! The only thing I can't figure out is that name with brackets doesn't show up. Any idea what to do please? :)
Hi! Thank you this is very helpful. Is it also possible to include the subject line in the mail merge? Tried doing it multiple times but no luck.
Oh I don't know actually. Have you tried including a replacement tag like {{Subject}} in the draft email?
Seems like I can't edit the script for the 2nd method. Is there any way for me to edit my name?
Hi Jimmy. Can you elaborate on how to send attachments using second method.
Hi, Shafeez here from Malaysia. It’s incredibly awesome tips! btw, would u mind to share how u do that signature? Cheers
Thanks! Yep I use Wisestamp
Does this go to the inbox? Or does sending the same email to many addresses very fast wont this go to the spam folder
thank you! that helps a lot:) btw, how to use the mail merge addon to send to different email address while cc to different email address at the same time? THANK YOU!
Hmm I'm not sure you could try putting the placeholder for a column in the CC area
If I done this method, the other email I'd owners will they see it the entire I'd that I put for sending
Yes they will unless it's extremely long
Hi Jimmy. Thanks so much for this. When I open the copy of the Sheet I can't see the Mail Merge Menu. Any idea why not? Mike
Hi Jimmy. I worked it out. It needed permission to show me the MailMerge menu
@@mikeroarty7588 Ah glad you've worked it out Mike!
Nice info, As the 1st method has a free limit of 50 recipients, what is the limit for method 2?
Same as the Gmail limits linked in the description
Does anyone know how to edit the code to send BCC or CC to multiple people?????
Hi Jimmy, great video. Thanks for the instruction.. I'm actually having the same problem as Lindlee.. {{First name}} does not show up; I get "Hi , " ... I've tried testing this out many times but get the same result. Any ideas why?
Thanks Kristo. I haven't seen this issue personally. Could be a space or extra character in the place holder or column name. Have you tried gmass?
I am getting the same issue? What should I do?
Hi Kristo, did you figure it out? I'm having the same problem. Please share solution if you have :) thanks
@@stocksinside6257 did you find a solution, please help :) if you did
Any updates? :)
the e-mails go into unwanted mails can anyone help me ?
Thank you very much. Option #2 is fab. :))
No worries. Agreed!
Does not work! On sheets addons - yet another mail merge (YAMM)-help (no choice of Start Mail Merge)
Can scripts do all these things that YAMM does: records if recipient has opened my email, if they clicked any link (not each link), and if they respond, and I can include a link to unsubscribe?
If you write your own they could. This one won't
Hello, Do you know if Gmail mail merge has set a limitation on number of the daily emails?
thanks!
Yep you can find a link to that article in the description
When I click on Merge, I get an error "Exception: The starting column of
the range is too small". The script does not run. What does this
mean?
I'm not sure sorry. It's not my script. But I would just make sure you've set it up exactly the same as the video first. Then try expanding on it
@Victor G Oh damn. I wonder if they are putting those limits on everyone
Hi! I tried using it but it doesn't show the name on the greetings?
Is Excel essential? Or could one use Libre office flavour spreadsheets thanks
Excel isn't used in this video. Both methods work with Google Sheets.
To use Libre you'd need to see if someone has made an extension for it
for some reason the squiggly backets don't work for me... The text inside them is completely identical to the sheet but in the actual email it doesn't show up :( any idea what the problem could be?
Hmm not sure. Do you have a space in between the bracket and the text
@@_jimmyrose no just {{text}} but it shows up as nothing in the email. I tried the second option you showed, maybe it'll work in the first option...
@@vivian-ve sounds like there might be something wrong in the spreadsheet then. It's also worth trying Gmass it's what I use now csnare.com/gmass
Hi , I like to send a report pivot screenshot from g sheet to an email,
Please suggest how to do this
I've never done it so I don't know. I doubt it's possible but maybe you can find a way
Thanks for the infos. Nice personality and voice!
Thank you!
08:48 This stupid guy forgot to mention {{recipient}} lol
@@vipulagora1325 Aw struggling to work out how to use it buddy?
Hi. May I know if it is okay to change the column name for example from First name to Name? And I tried copying and pasting exactly the First name to my draft {{First name}} but when I did the test mail it only shows Dear ,
Yeah you can name the columns whatever you like, as long as the replacement tag exactly matches it in the draft
@@_jimmyrose thanks for your response. this is awesome.
btw, along the sending of email,there is a notification saying "Exceeded maximum execution time Details. Message details Exceeded maximum execution time. What should I do? The only thing for me to know where the email automation had stopped in checking my sent email. Are there other ways to resolve this? Thanks
@@lindleevillanueva13 hmm I haven't seen that before. I don't know :(
It could be a one off problem. If it does it every time, check out the original page and see if there is a way to get help.
@@_jimmyrose okay will do that. And oh, do you have tutorial for putting unsubscribe link in sending this bulk email? how to do it? Thanks in advance for you immediate response.
Gmail keeps saving my emails as a draft, every 30 seconds. I have been getting text messages that are from email addresses, not phone numbers. I know they're spam but I clicked one to see what it is, and then my email started doing that. Virus scan says no virus. Wtf
Is there a way to send 1500 mails at once from a G-Suite account for free?
No. It'd all go to spam anyway
Thanks so much, it's very interresting. Great job :)
Thanks Mo
what kind of sensitive information is your app capturing?
The app doesn't dictate what is collected. Customers enter their own questions for their clients. It's currently against ToS to collect sensitive personal data as defined by GDPR
For the 2nd method, is there any limit to how many recipients it can be send to?
Great sharing here sir!
Edit: got my answers.
Super helpful, thanks!
No probs thanks for dropping by
Very nice video
Can we schedule every email in different time
Thanks Ani. You can with the Yet Another Mail Merge tool
@@_jimmyrose can we do with google Docs appscript
@@anisharma7889 I don't believe so
Can you schedule thousands of emails over a series of days?
Hi, I have some images in the body of the message, but the images doesn't arrive to the recipient, is there something I have to add to the script to work in this case? I'm using the second method. Best regards.
Is it not working or are you just asking? I'm pretty sure I tested this with option 1 and it worked.
I just found someone saying that this method works sites.google.com/site/scriptsexamples/available-web-apps/mail-merge/documentation/known-issues/images-are-broken-in-emails-sent
Looks like you have to host the images separately and embed into the email via a URL
@@_jimmyrose Thanks for your quick response.
I'm trying to place inline images with the body message, and the images shows broken, they appear at the end as attachments, but I need them inline with the text.
So I did a research and this worked for me:
You can utilize Google Drive for image hosting purposes via Doc.
1. Open Google Docs and create a new document and give it a name like "Images for Emails"
2. In the top right corner of the Google Docs interface, click the Share button.
3. From the sharing window, select Advanced
4. Under Who has access click Change... from the right column.
5. Select On - Anyone with the link and confirm the change by clicking Save
6. Insert the image into the Google Doc
7. Select the image and copy it from the Google Doc and paste it into the Compose window.
As long as the Google Doc is not deleted from your Google Drive, the image will always be accessible and will display properly when sent.
I hope this helps other people trying to do the same.
Here is the original article: support.streak.com/en/articles/2546087-inline-images-not-working-in-a-mail-merge
@@rolandoortega3220 glad you found a fix. Looks like the same fix described in the post I linked
This is great - I was able to get the YAMM working fine, but I noticed when I sent one to myself, it had a gray subheader indicating it came from YAMM (it looks a little unprofessional in my mind. Of course I am using the free version so maybe that is the issue. Any thoughts?
I've never seen that before. I don't think I've even seen a subheader in Gmail. Where's it showing up?
@@_jimmyrose you are not in use for your reply
@@_jimmyrose 😡😡😡😡😡😡😡
Hope you are looking for a few days. I have a look at the moment.
@@yaalmiraz3605 wat
Thanks for this... This should have been 3 minutes long by the way.
Then someone would complain it was too fast and they couldn't follow.
Can't edit the script for some reason :/
You might have to copy it into your account
Is it possible to send 5000+ email per day?
No
Yes
Name and other customised things are not taken up
Not sure what you're saying
I have one gsuit account so i can send 1500 emails at a time right. I mean bulk email marketing!!
I definitely wouldn't use that for email marketing. You're almost guaranteed to end up in spam
@@_jimmyrose if i will do warmup , thn mail will reach to spam?
Also if i send 500 in 3 times then ??
@@AsishEntertainments Gmail isn't made for bulk email
@@_jimmyrose then how yamm and gmass providing such mail merge services!! We can send 1500 mails by using their services!!
How does following up work?
As in automatically? WIth YAMM: support.yet-another-mail-merge.com/hc/en-us/articles/211318809-Send-a-follow-up-campaign-to-get-better-open-rates-and-replies
With thee script, it's manual. If you want to send auto replies you'll almost definitely need a premium product. Look at QuickMail, Mailshake etc
How Many Emails we Can send In a Day Sir ?.
That's covered in the video and there are links in the description
@@_jimmyrose Thank You So much .!!
Thank You soo much!!
No probs :)
14 minutes for this tutorial 🤪
Great video, as usual Jimmy!
I'm a little disappointed though... I believe I heard you using your mouse to switch browser tabs instead of keyboard shortcuts. #letdown 😂
Haha keyboard shortcuts for tabs assume I have any idea where the tab I need is
No vk
7:23
Naic