THANK YOU SO MUCH! So many said mail merge was only possible with the desktop app but I knew there HAD to be another way. I cannot thank you enough. God bless you and your family!
THANK YOU VERY MUCH!!!! THIS WORKED ABSOLUTELY PERFECTLY. Microsoft removed mail merge for its new outlook app and it was very frustrating. However, you solved my problem with no complaints whatsoever. Thank you for your tutorial. All steps were nicely explained and concise.
Great Video! I need to create a similar flow for sending a table via mail (to and cc). Do you believe it's possible? Excel table with 7 columns and hundreds of rows: ‘code’ column, ‘description’ column, ‘quantity’ column, ‘total value’ column, ‘owners’ column, ‘manager’ column, and ‘functional managers’ column. I need to send the table by email to each owner, manager, and functional manager, but only with the rows relevant to them. The rows for owners, manager, and functional manager are populated with their email addresses. Please note that there can be more than one owner (multiple email addresses in the same row).
Hi, You are welcome. Yes, you can create HTML emails. At 6:15 , select the 'Toggle code view' option when creating the email body; it opens the editor to write code. Here is the screenshot: i.imgur.com/1su6qfU.png I hope this helps. Thank you.
Hi Amanda, Welcome! Add your test email address to the contacts list and remove any other contacts. This way, you can safely run a test flow. Once the test is complete, re-add the other contacts to the list and execute the flow.
Brother, how can i add table in this to send individual mails to emp about there work detials which is present in onedrive Excel file please reply. I tried creatinf HTML code and compose action but none of them are working.
It is really good video thank you. I couldn't add my pdf attachment. When I send it, it needs to be downloaded by the receiver. Do I do anything wrong? Besides how can I add my email signature? I have seen your other video for adding a picture to email body but those pictures should be public and reachable. Are there any other methods?
Hi, 1. For the attachment, I forgot to mention that you need to add the file extension when you write the filename. At 6:54 , write the filename as Flyer.pdf, and then the recipients can open the PDF. If the file is in a different format, add the extension name accordingly with the filename. 2. For the signature, you can write your text signature while writing the email in the Send Email action. It doesn't support adding images. You can add external images using this method: th-cam.com/video/4nuO8H4mk5c/w-d-xo.html 3. If you have access to the Microsoft 365 admin, you can add a signature with this method (Still, it requires an external image): th-cam.com/video/ZMeDVRXwFyw/w-d-xo.html Thank you.
@@technologiate One final question, is there a limit with 256 records for mail merge? I received an error and needed to divide my emails to 256 batches. Is there an adjustment I need to do?
Thanks for the video. Can we set time delay between 2 emails like if 1st email send then flow will wait 10 second and then send the 2nd mail.. is it possible? Eagerly waiting for your response and thanks in advance! 😊
Hi, It doesn't have an option to preview the email like you can do on Mail Merge on the Outlook desktop application. You can keep your email adress only in the contact list and run the flow to see how it looks, then you can fill the contact list. Thank you.
Hi, very clearly and concisely described. Thanks. Quick question, can power automate be used to send emails with attachments on the desktop version of outlook?
Hi, I made two videos on Mail Merge on Outlook with attachments, CC and BCC. Please check the videos: 1. Mail Merge with Attachments in Outlook | Outlook Mail Merge with Attachment: th-cam.com/video/z0AnVbBoAVA/w-d-xo.html 2. Mail Merge with CC, BCC & Attachments | Mail Merge with CC | Mail Merge with BCC: th-cam.com/video/pNDdKHuBYw8/w-d-xo.html And this is the video for Mail Merge on Outlook: th-cam.com/video/NikC2cJ_tHQ/w-d-xo.html Thank you.
It works with the free version of Outlook as well. Make sure you do not select the Office 365 actions in the Power Automate flow. Excel online is free.
Hi, you can send up to 10,00 emails per day with a 365 account: learn.microsoft.com/en-us/office365/servicedescriptions/exchange-online-service-description/exchange-online-limits?redirectedfrom=MSDN#sending-limits-1
when i am trying to sign in it is showing that Microsoft account doesn't exist how to solve this i have previously make a flow but when i am making another it is showing error
Did you select the correct action? It has two different actions, one for Office 365 and another for Outlook free. You should choose the one that fits your account type. Thank you.
Hi, you can send up to 10,00 emails per day with a 365 account: learn.microsoft.com/en-us/office365/servicedescriptions/exchange-online-service-description/exchange-online-limits?redirectedfrom=MSDN#sending-limits-1
Hi, I have been trying to send 1000 for the past 2days. But what is happening, around 200-250 mails are getting sent. Others are not getting delivered. At the end, we are not able to send any mails from our outlook account. We are using Microsoft 365 basic business plan. Could you please rectify this?
Hi, For bulk marketing emails, you should not use any email services like Outlook or Gmail; instead, use email marketing providers like Mailchimp, Brevo, etc. Outlook may have set a limit on the account when it noticed something abusive; also, the recipient's email providers can disregard your emails when they notice something spammy. Thanks.
How can we set the limitation, Ex: i have the list of 1000 emails considering sending limitations how can we set how many emails to be sent in 1 second/minute/hour
Hi, for the attachment, I forgot to mention that you need to add the file extension when you write the filename. At 6:54 , write the filename as Flyer.pdf, and then the recipients can open the PDF. If the file is in a different format, add the extension name accordingly with the filename. Thanks.
Thank you so much. It worked. I was trying to add my logo in email body as embedded image. Followed many videos. But image is not loading. Do you have any video regarding the same?
Hi, Please add the file extension with the file name when you are adding the file ( 6:54), put it in the file name. For example, if your file is a Microsoft Word file, add filename.docx to the file name box.
*Send Emails with Separate Attachments using Power Automate:* th-cam.com/video/WcNqe3hRZxk/w-d-xo.html
thank you so much for this easy step by step mail merge! saved me so much time! and very easy to follow
You're welcome! I'm glad it was helpful and easy to follow!
This is 1000x more intuitive and helpful than Mail Merge on Word. Thanks for the awesome video!
You're very welcome!
THANK YOU SO MUCH! So many said mail merge was only possible with the desktop app but I knew there HAD to be another way. I cannot thank you enough. God bless you and your family!
You're very welcome! I'm glad you found the video helpful. Thank you for your kind words. Blessings to you and your family too! 😊
THANK YOU VERY MUCH!!!! THIS WORKED ABSOLUTELY PERFECTLY. Microsoft removed mail merge for its new outlook app and it was very frustrating. However, you solved my problem with no complaints whatsoever. Thank you for your tutorial. All steps were nicely explained and concise.
Thank you.
You may check out this video if you need to send separate attachments for the recipients: th-cam.com/video/WcNqe3hRZxk/w-d-xo.html
Mate!!! You have saved me time, patience and money! You deserve a medal!!!
Thanks a ton! I’m just happy to hear it helped you out! 😊
Thanks!
Thank you so much for your generous support! I'm truly grateful! 🙏✨
Great Video! I need to create a similar flow for sending a table via mail (to and cc). Do you believe it's possible? Excel table with 7 columns and hundreds of rows: ‘code’ column, ‘description’ column, ‘quantity’ column, ‘total value’ column, ‘owners’ column, ‘manager’ column, and ‘functional managers’ column. I need to send the table by email to each owner, manager, and functional manager, but only with the rows relevant to them. The rows for owners, manager, and functional manager are populated with their email addresses. Please note that there can be more than one owner (multiple email addresses in the same row).
Hi
Your video was really useful
Thanks for that
Can u help, how to send same email in HTML format
Thanks
Hi,
You are welcome.
Yes, you can create HTML emails. At 6:15 , select the 'Toggle code view' option when creating the email body; it opens the editor to write code. Here is the screenshot: i.imgur.com/1su6qfU.png
I hope this helps.
Thank you.
This was very helpful. I would like to know how to run a Flow test.
Hi Amanda,
Welcome!
Add your test email address to the contacts list and remove any other contacts. This way, you can safely run a test flow. Once the test is complete, re-add the other contacts to the list and execute the flow.
This is great. But how can I add a corporate signature at the end of the email? It's on an image file.
Hi, you can follow this method to add an image in the email body using HTML code: th-cam.com/video/4nuO8H4mk5c/w-d-xo.html
Brother, how can i add table in this to send individual mails to emp about there work detials which is present in onedrive Excel file please reply.
I tried creatinf HTML code and compose action but none of them are working.
Can you show us how to send a different attachment to each recipient using mail merge.
Okay, I will create an add-on video soon.
Hi, please check out this new video: th-cam.com/video/WcNqe3hRZxk/w-d-xo.html
It is really good video thank you. I couldn't add my pdf attachment. When I send it, it needs to be downloaded by the receiver. Do I do anything wrong? Besides how can I add my email signature? I have seen your other video for adding a picture to email body but those pictures should be public and reachable. Are there any other methods?
Hi,
1. For the attachment, I forgot to mention that you need to add the file extension when you write the filename. At 6:54 , write the filename as Flyer.pdf, and then the recipients can open the PDF. If the file is in a different format, add the extension name accordingly with the filename.
2. For the signature, you can write your text signature while writing the email in the Send Email action. It doesn't support adding images. You can add external images using this method: th-cam.com/video/4nuO8H4mk5c/w-d-xo.html
3. If you have access to the Microsoft 365 admin, you can add a signature with this method (Still, it requires an external image): th-cam.com/video/ZMeDVRXwFyw/w-d-xo.html
Thank you.
@@technologiate thank you. I could send the pdf now. It helped me a lot. Have a nice day.
@@technologiate One final question, is there a limit with 256 records for mail merge? I received an error and needed to divide my emails to 256 batches. Is there an adjustment I need to do?
@agureller Hi, the send email action has a limitation of 256 recipients in a go.
Thanks for the video. Can we set time delay between 2 emails like if 1st email send then flow will wait 10 second and then send the 2nd mail.. is it possible? Eagerly waiting for your response and thanks in advance! 😊
Hi,
You can set a 'Delay' action after the 'Send an email (V2) action. See the screenshot: i.imgur.com/xbOsArC.png
@@technologiate really thanks for the prompt response. You have gained one subscriber 🎆. Waiting for all your future videos ❤️
@@vipin_waghmare Thank you. This means a lot.
This video might be helpful for you: th-cam.com/video/WcNqe3hRZxk/w-d-xo.html
Is there a way to preview the mail merge before sending? and Is there a way to left line and middle line any of the text in the body?
Hi,
It doesn't have an option to preview the email like you can do on Mail Merge on the Outlook desktop application. You can keep your email adress only in the contact list and run the flow to see how it looks, then you can fill the contact list.
Thank you.
So clear and complete. Many thanks!🙂
Thank you 😊
Hi, very clearly and concisely described. Thanks. Quick question, can power automate be used to send emails with attachments on the desktop version of outlook?
Hi,
I made two videos on Mail Merge on Outlook with attachments, CC and BCC.
Please check the videos:
1. Mail Merge with Attachments in Outlook | Outlook Mail Merge with Attachment: th-cam.com/video/z0AnVbBoAVA/w-d-xo.html
2. Mail Merge with CC, BCC & Attachments | Mail Merge with CC | Mail Merge with BCC: th-cam.com/video/pNDdKHuBYw8/w-d-xo.html
And this is the video for Mail Merge on Outlook: th-cam.com/video/NikC2cJ_tHQ/w-d-xo.html
Thank you.
is it possible to insert a picture/photo inside the body email message?
Please watch this video: th-cam.com/video/4nuO8H4mk5c/w-d-xo.html
What if i don't have the Excel subscription? i have only outlook basic plan
It works with the free version of Outlook as well. Make sure you do not select the Office 365 actions in the Power Automate flow. Excel online is free.
Hi, is this also can be apply for sending different attachments to the recipient?
Thanks for your video. How to link signature to subject with images and links?
Could you please explain it a little bit?
Great instruction! Very clear and helpful.
Thank you
How can I insert pics, logos etc in the body of email?
You can add images hosted externally: th-cam.com/video/4nuO8H4mk5c/w-d-xo.html
It was so helpful, thank you so much but can I use do this with different attachments?
Thank you.
For that, you need to create a column where you will define the paths of the attachments for each of the recipients.
@@technologiate does the flow same as in this video or get content file path changes? thank you :)
Dude, that is amazing! BTW, is it unlimited or have any limitations(In the free version)?
Hi, you can send up to 10,00 emails per day with a 365 account: learn.microsoft.com/en-us/office365/servicedescriptions/exchange-online-service-description/exchange-online-limits?redirectedfrom=MSDN#sending-limits-1
This is a great video. However, I am using the Sharepoint O365 version and I can't add Power Automate. Any advice how to do this?
Anyone know how to add signature.
can we add html image as a body?
Hi,
It doesn't support inserting custom HTML.
perfect explaination, thanks a lot
You are welcome 😊
you saved the day :) @@technologiate
when i am trying to sign in it is showing that Microsoft account doesn't exist how to solve this i have previously make a flow but when i am making another it is showing error
Did you select the correct action? It has two different actions, one for Office 365 and another for Outlook free. You should choose the one that fits your account type. Thank you.
Excellent content
Thank you🙂
how many mails can we send through excel power automate
Hi, you can send up to 10,00 emails per day with a 365 account: learn.microsoft.com/en-us/office365/servicedescriptions/exchange-online-service-description/exchange-online-limits?redirectedfrom=MSDN#sending-limits-1
Hi, I have been trying to send 1000 for the past 2days. But what is happening, around 200-250 mails are getting sent. Others are not getting delivered. At the end, we are not able to send any mails from our outlook account. We are using Microsoft 365 basic business plan. Could you please rectify this?
Hi,
For bulk marketing emails, you should not use any email services like Outlook or Gmail; instead, use email marketing providers like Mailchimp, Brevo, etc. Outlook may have set a limit on the account when it noticed something abusive; also, the recipient's email providers can disregard your emails when they notice something spammy. Thanks.
@@technologiate OK thank you.
@@banuchithraa.r.8200 You are welcome
even i use attachment format name accordingly it doesnot work
Hi, could you please explain the issue briefly so I can understand?
Thanks a lot will try this
This was a useful video. Thank you for sharing!
You are welcome
How can we set the limitation,
Ex: i have the list of 1000 emails considering sending limitations how can we set how many emails to be sent in 1 second/minute/hour
Hi,
You can set a 'Delay' action after the 'Send an email (V2) action. See the screenshot: i.imgur.com/xbOsArC.png
@@technologiate How can we enable delivery note and read receipt?
thanks for this video
So nice of you
how to embed the table in to mail merge body content
Hi,
It doesn't support embedding a table in the email body.
How to do mail merge through Shared mail box
I was able to insert a link and now I cannot copy and paste. Any suggesstions?
Hi Amanda,
Could you please explain it a little bit?
Where did you insert the link, and what do you want to copy?
Thanks.
What is limit per day?
Hi, it's 10,000 per day
Is this the outlook mail merge limit right?
@banuchithraa.r.8200 This is the email sending limit for an account.
@@technologiate I would like to know for mail merge. Please?
@banuchithraa.r.8200 Same for mail merge
I added PDF file as an attachment but it's not working.
Hi, for the attachment, I forgot to mention that you need to add the file extension when you write the filename. At 6:54 , write the filename as Flyer.pdf, and then the recipients can open the PDF. If the file is in a different format, add the extension name accordingly with the filename. Thanks.
@ thanks for your prompt reply. It worked 👏. I want to attach 2 files. So should I add get file content action twice?
@azrashaikh3883 Yes
Thank you so much. It worked. I was trying to add my logo in email body as embedded image. Followed many videos. But image is not loading. Do you have any video regarding the same?
Hi
Here is the video for embedding images in the send-an-email action: th-cam.com/video/4nuO8H4mk5c/w-d-xo.html
Thank you.
Thanks my guy
You are wecome 😊
@@technologiate How many mails can we send with Office 365 and power automate in a day?
But in my case the attachment which I am sending is getting corrupted pls help
Hi, Please add the file extension with the file name when you are adding the file ( 6:54), put it in the file name. For example, if your file is a Microsoft Word file, add filename.docx to the file name box.
Very perfect explanation ❤sir
Thank you
what if my mail merge is failing?
how to check the error
Good Video !!
*How to use Mail Merge in the Outlook Desktop Application:* th-cam.com/video/NikC2cJ_tHQ/w-d-xo.html
genius!
Thank you
Champ ❤