Learn how to perform a mail merge between Gmail and Google Sheets with native functionality. Concatenate function: sheetshelp.com... More info on mail merge: workspaceupdat... Add-On to Keep Your Data Sorted: workspace.goog...
Пікірлер: 34
@MichealS-bi8xt4 ай бұрын
Thank you for sharing this valuable video on Gmail and Google Sheets mail merge without any add-ons! Adding Tomba Email Finder for Google Sheets addons will definitely make the process even more efficient. Great tip!
@user-ym6dg2vq8g9 ай бұрын
This was so helpful! You saved me so much time and worry with this tutorial.
@ProlificOaktree9 ай бұрын
Glad it helped!
@quielsystems Жыл бұрын
Men that's awesome. Thank you!
@ProlificOaktree Жыл бұрын
Right on bro
@user-tr1zt1mq7h7 ай бұрын
Thank you! This worked out perfectly!
@5655sam6 ай бұрын
Thank you! Saved the day.
@ProlificOaktree5 ай бұрын
Glad it helped!
@vishnusaivanka804310 ай бұрын
Thanks but I'm unable to send emails if the same email id's are present in the same column
@Benoffor-k4oАй бұрын
Whenever I try to insert the mail list from the my googlespreadsheet, I keep getting an error message that "Check the email column Make sure there are no missing emails, and every email is in the right format"....... Even though i have checked all that
@user-yz3so9hy2o6 ай бұрын
hey there, thanks for the video ,very helpful indeed, I need to ask you a question. how should I schedule the mail merge list? I mean I want to send emails from different sheets on different days and times, how am I able to do it? is there any plug in gmail has? Please let me know, thanks
@masonwilliamson26777 ай бұрын
Hello and thank you for the video. If I have a google spreadsheet that frequently gets new rows added to it with new prospect's information can I have gmail use a saved email template, merge some of the google spreadsheet data into the email template and send it to the email address in that new google spreadsheet row? Thanks for your time.
@ContinYou-di6nd7 ай бұрын
It wasn't recently added. Its been around for a while and they reduced the functionality of the mail merge, such as the ability to customize the subject line and posting to the google sheet the date/time it was sent.
@benjaminoffor106628 күн бұрын
I keep getting this error: Make sure there are no missing emails, and every email is in the right format. ANY HELP?
@jasonhiggins.38538 ай бұрын
Hello, great video. I have lists of email addresses which are mainly domain emails but there are also gmail emails mixed through the lists. Can anyone tell me how i can remove the gmail emails please.
@ProlificOaktree8 ай бұрын
Something like IF(RIGHT(A1),9="gmail.com"),"",A1. Totally untested so use it as a starter formula.
@hierismara7 ай бұрын
Can i add my own variable's? For example instead of first name a variable called Company_name
@user-sk9lm4en1g10 ай бұрын
I am currently trying to do this for my organisation, I am facing a bit of trouble in the last step. Gmail throws this error 'failed to send preview email. Multi send does not support confidential mode, reply mode or scheduled emails' I am not scheduling this email, do you have any idea how I can fix this?
@ProlificOaktree10 ай бұрын
No, sorry. I hope you get it worked out.
@simonfernandes86723 ай бұрын
I have a paid google workspace Business Account. How do i enable this feature?
@ProlificOaktree2 ай бұрын
It should be on by default. If the options aren't there, you will have to talk to your admin.
@victorlozano67154 ай бұрын
Is the paid version better than the free version?
@ProlificOaktree3 ай бұрын
What paid version?
@ekowreel10 ай бұрын
Will the mail land in inbox and can it be used for email marketing ?
@ProlificOaktree10 ай бұрын
Yes, it should.
@Bhargav21968 ай бұрын
Any idea how to add cc and BCC
@ProlificOaktree8 ай бұрын
Nope! It doesn't appear to be designed for that.
@juliaelenaidelson500111 ай бұрын
Mine still says the format isn't right
@ProlificOaktree11 ай бұрын
Uh oh;)
@MDDanceCompany7 ай бұрын
@@ProlificOaktree same , any suggestion ?
@ProlificOaktree7 ай бұрын
@@MDDanceCompany That sounds like the type of error that could be caused by many different things. So, as much as I would like to be able to, I can't offer a reasonable guess!