*Mail Merge in Outlook:* th-cam.com/video/NikC2cJ_tHQ/w-d-xo.htmlsi=X4W42fj_MB5sqbMN *Mail Merge with attachments in Outlook:* th-cam.com/video/z0AnVbBoAVA/w-d-xo.htmlsi=l97ZN6YMO67-0jgF *Mail Merge with CC, BCC, and attachments:* th-cam.com/video/pNDdKHuBYw8/w-d-xo.htmlsi=H9NHg3SmdOXgazgB
Hi I am having issues with the mail merge functions. Everything seems to work fine, however my sent emails do not have any paragraphs. I clearly separated my content into distinct paragraphs, but why does it happen and how to fix it?
Hi, Did you copy the text into the compose email? Sometimes, it doesn't respect the line breaks when you copy the text. Even though you haven't copied the text, please create the line breaks again. It should work. Thanks.
the email which we write in the mail body, after sending email all the data i typed are becoming one paragraph sapces are no there after sending the emails
Hello! Many thanks for this tutorial. It is brief, accurate and bang-on. I just have one question. I needed to add First names in the mail template and did add the column name with curly brackets but except the name showing up in the email, everything else worked. Just wanted to understand what did I miss. Will appreciate your help and response, thanks.
Hi, thank you so much for your tutorial. I am using a domain email which already connected to gmail. May I ask that is this mail merge enable to send bulk emails which using the domain email as the "sender"? Because there seems no choice for the senders, but I need to send the emails by the domain email. thanks so much!
Hi, It doesn't work with the connected custom domain email. Before writing this comment, I tried changing the From email to a custom email in the draft. But when it sends the email, it uses the Gmail account only. Workaround: If you have the Outlook application installed on your computer, you can connect the custom domain email with the Outlook app (Watch this guide: th-cam.com/video/CUsvXJ9dcW8/w-d-xo.html ). Then, set the custom domain email as the default on Outlook and send the mail merge through Outlook ( Watch this guide: th-cam.com/video/NikC2cJ_tHQ/w-d-xo.html ). I hope this helps you. Thank you.
@@technologiate Thanks for your reply. What if I create a new custom domain email in Google, will it work? Because our works are in Google drive and we get used to use Google systems. Thank you!
It will work if you get a Google Workspace account for the custom domain (Here is a guide to start: th-cam.com/video/awHYJuKEYik/w-d-xo.html ), then you can use mail merge on the custom domain email. When you have a Google workspace account, it is easier to send mail merge emails. Thank you.
@@technologiate is the daily sell limit to certain emails or all emails. like can I keep sending to one email that I have sent too ? Sorry if that doesn’t make sense
Hi, I am using {{First name}} but it's not working and not working for other columns as well, Could you please tell me the possible reasons why it's not working in my case.
This is really a great tutorial, thanks for that. Unfortunately you can only send less than 100 emails per day and now I have to find something else to send the rest of my 650 emails.
Hi, It supports CC, but the CC email would be the same for everyone. To add the CC, open the script ( as shown at 1:57 ), go to line 98, remove the front slashes before cc to enable it, and replace the a.cc@email.com with your CC email address. Save the script. Please let me know if this works. Thanks.
Hi, it's up to the reputation of the sender's email. Also, when you send bulk emails, they often it goes to spam. For bulk emails, you can use a service like Mailchimp or Brevo.
*Mail Merge in Outlook:* th-cam.com/video/NikC2cJ_tHQ/w-d-xo.htmlsi=X4W42fj_MB5sqbMN
*Mail Merge with attachments in Outlook:* th-cam.com/video/z0AnVbBoAVA/w-d-xo.htmlsi=l97ZN6YMO67-0jgF
*Mail Merge with CC, BCC, and attachments:* th-cam.com/video/pNDdKHuBYw8/w-d-xo.htmlsi=H9NHg3SmdOXgazgB
Nice Explanation but Why emails are showing in spam section. please update me on this if you have any solution.
Hi I am having issues with the mail merge functions. Everything seems to work fine, however my sent emails do not have any paragraphs. I clearly separated my content into distinct paragraphs, but why does it happen and how to fix it?
Hi,
Did you copy the text into the compose email? Sometimes, it doesn't respect the line breaks when you copy the text.
Even though you haven't copied the text, please create the line breaks again. It should work.
Thanks.
@@technologiate Wow I did not expect a fast reply from you haha! Anyways I typed out the entire email myself but it still does not work 🤷.
Can you test it with an extra line break?
I have noticed this issue on Power Automate, and manual line breaks always fix the problem. Thanks.
@ alright I'll try thanks for the help!
You saved my day! thanks
You are welcome 🙂
the email which we write in the mail body, after sending email all the data i typed are becoming one paragraph
sapces are no there after sending the emails
Did you copy the text from another document into the body of the email?
how to schedule sending email? i want to send email by day and time?
Hello! Many thanks for this tutorial. It is brief, accurate and bang-on.
I just have one question. I needed to add First names in the mail template and did add the column name with curly brackets but except the name showing up in the email, everything else worked.
Just wanted to understand what did I miss. Will appreciate your help and response, thanks.
Hi I tried adding Cc column but its not sending to the email on Cc column I created. Is there a script available with Cc functionality?
Only for Gmail please, not outlook.
ONly recipent working in mail other thing i add but not working
Same issue
Thank you very much for the tutorial. Really saved my day.
You are welcome.
Hi, thank you so much for your tutorial. I am using a domain email which already connected to gmail. May I ask that is this mail merge enable to send bulk emails which using the domain email as the "sender"? Because there seems no choice for the senders, but I need to send the emails by the domain email. thanks so much!
Hi,
It doesn't work with the connected custom domain email.
Before writing this comment, I tried changing the From email to a custom email in the draft. But when it sends the email, it uses the Gmail account only.
Workaround:
If you have the Outlook application installed on your computer, you can connect the custom domain email with the Outlook app (Watch this guide: th-cam.com/video/CUsvXJ9dcW8/w-d-xo.html ). Then, set the custom domain email as the default on Outlook and send the mail merge through Outlook ( Watch this guide: th-cam.com/video/NikC2cJ_tHQ/w-d-xo.html ).
I hope this helps you.
Thank you.
@@technologiate Thanks for your quick reply. How about setting the custom domain email as the default on gmail? Does it work? Thanks so much!
@laiyungcheung9543 No, it doesn't work
@@technologiate Thanks for your reply. What if I create a new custom domain email in Google, will it work? Because our works are in Google drive and we get used to use Google systems. Thank you!
It will work if you get a Google Workspace account for the custom domain (Here is a guide to start: th-cam.com/video/awHYJuKEYik/w-d-xo.html ), then you can use mail merge on the custom domain email.
When you have a Google workspace account, it is easier to send mail merge emails.
Thank you.
Thanks this worked but why does some emails says serviced invoked where the category email sent is?
This is because of the daily sending limit.
@@technologiate is the daily sell limit to certain emails or all emails. like can I keep sending to one email that I have sent too ? Sorry if that doesn’t make sense
It is the limit for the sending account, and it does not matter whom you are sending.
@@technologiate ok thanks what’s the daily?
Hi,
I am using {{First name}} but it's not working and not working for other columns as well, Could you please tell me the possible reasons why it's not working in my case.
Does it send the email?
@@technologiate yes
@@sumitrawat4426 Could you please send me the email with the Google Sheet link (public)? Make sure to delete all the data you have.
@@technologiate same problem arising with us
Same issue in my case as well
This is really a great tutorial, thanks for that. Unfortunately you can only send less than 100 emails per day and now I have to find something else to send the rest of my 650 emails.
Hi, the limit is from Gmail, you can try Outlook with this method: th-cam.com/video/ItrVEQCwKW0/w-d-xo.html
@@technologiate Thanks.
@iHayri1 You are welcome
How to add cc also?
Its showing that failed to send email no recipient please suggest
Hi, by any chance, did you rename the column header for the recipient?
@@technologiate yes, now I got it, thank you so much it saved lots of my time
@@naseemashaik55 Awesome to hear it helped! Don't forget to hit subscribe for more helpful content. Thanks! 🌟
Thanks for sharing this video. It was helpful
You are so welcome!
if i use {{ in body of mail its not working bro
Hi,
Could you ensure the column headers match the text inside the curly brackets without spaces?
@@technologiate yes I did that but its not working
@technologiate Even i am facing the same issue, In Body of the Email the {{First name}} Is not working
Hi,
I am not sure what could be the issue.
If I had a look, I can suggest the solution.
How do i add attachments
Hi,
You need to attach the file to the draft.
how many emails can i send per day with this method?
It depends on the limit Gmail sets for the account.
i have question how keep in Cc in that is there any way??
Hi,
It supports CC, but the CC email would be the same for everyone.
To add the CC, open the script ( as shown at 1:57 ), go to line 98, remove the front slashes before cc to enable it, and replace the a.cc@email.com with your CC email address. Save the script.
Please let me know if this works.
Thanks.
This is not working @@technologiate
It worked for me.. thanks a lot
Not Working
Nice Explanation but Why emails are showing in spam section. please update me on this if you have any solution.
Hi, it's up to the reputation of the sender's email. Also, when you send bulk emails, they often it goes to spam. For bulk emails, you can use a service like Mailchimp or Brevo.