Power Automate Mail Merge with Individual Attachments | Send Mails with Separate Files

[@technologiate]

*Mail Merge without attachments using Power Automate:* kzbin.info/www/bejne/f6XVh3iHeNx-jZI

[@sagarpatel1252]

Thanks so much for this video! Your clear explanation helped me resolve my Power Automate issue, and I was able to successfully run the flow. Keep up the great work-your content is truly valuable!

[@charlotte-h8m2t]

I have the same issue here, one recipient received all the attachments with separate emails. I don't know what's wrong with my workflow?

[@charlotte-h8m2t]

@@technologiate Thanks for replying me. I send you my flow to your email yesterday. Please help to check what's going on with it. I've learned it for 3 days. Thanks

[@technologiate]

Hi, I saw your email; you sent the screenshot. Can you export the flow in a zip and send it to me. Thanks.

[@TimothylynchRoss]

Its great, I have a question , how much emails can be sent using this mail merge ? How to contact with you regarding some project?

[@technologiate]

Hi, Thank you. Please check out this page for the sending limit: support.microsoft.com/en-us/office/sending-limits-in-outlook-com-279ee200-594c-40f0-9ec8-bb6af7735c2e You can send me an email to hello [at] technologiate.com

[@tonytseng7780]

Hi - this is fantastic and just what I needed. I was able to get it to work. I did find an interesting bug (most likely user error) and that 1 of the recipients is receiving 2 emails with the same body but with different attachments. Any idea how this can be troubleshooted? Thanks again for a wonderful video. upon testing. It appears to be an issue with the first email in the table that receives as many emails and attachments as in the table. So, if I have 3 recipients in my table the first recipient receives 3 emails with the same body in the email but with different attachments.

[@technologiate]

Hi, I'm glad you found it helpful. Can you check the flow to see if the actions are in the right place? Have you added them in the correct loops, as in the video? One more thing: Did you place the contacts file in a separate folder from the attachments folder? It needs to be in a separate place; it is mentioned there. You can send me screenshots of the whole flow at hello@technologiate. I will have a look. Thanks.

[@gremmariealmajose4585]

Were you able to figure it out? Happening to me, too!

[@technologiate]

Hi, make sure to place the Contracts Excel in a separate folder.

[@ilovecatwalk1]

@@technologiateit is in a different folder. However, it’s still sending the 3 attachments to the same email separately. So I received 3 emails with different attachments in 1 email. If that makes sense? I really love how you explained and showed, I hope it works for me too!

[@technologiate]

@ilovecatwalk1 I am not sure what's causing the issue. If you can send me the flow by an email I will have a look, and I will send my flow so you can try it. Meanwhile I have recorded another video on this topic that sends multiple separate attachments. Monday is the day when the video is going to be published. I think it will be easy for everyone. Thanks

[@SabrinaLumina]

How about to include 2 attachments?

[@technologiate]

Hi, thanks for the suggestion, please check the new video on Monday. Thanks 😊

[@reviewphimnhanh7730]

hellow i want to do this. A person response to a form submission. it will check if the response is matched with the excel row . If it does it will email with the attachment . Can you help me on this ?

[@technologiate]

Hi, yes, it can be done. Power Automate has ready templates (i.imgur.com/cDJOBY9.png); you can customize this template with your data.

[@FauziaRehman]

Hi , thanks for great explanation. How can we modify this to send emails from shared mailbox? Also, if we have couple of more attachments, which steps should be repeated?

[@technologiate]

Hi, Thank you for the comment. You can connect the shared mailbox in the 'Send an Email (V2)' action. I haven't tried this since I don't have a shared box, but it should work. For multiple attachments for a recipient, the flow design would be different. We need more conditions before the 'Send an Email (V2)' action.

[@FauziaRehman]

I tried with shared mailbox option and the flow ran successfully but the get file content step is getting skipped with an error 'not specified'. Can you please suggest?

[@scholengroepinspira6131]

Is it still working? I copied the flow and used it last month. Today I needed it again, and it doesn't work properly anymore.

[@technologiate]

Yes, it works

[@reviewphimnhanh7730]

@@technologiatei tried the link and it is private . Can i have acces to the video?

[@technologiate]

@@reviewphimnhanh7730 Sorry for the inconvenience, I had to pull down the video because the process had some issues with the file conversions on different email servers; will upload a new video soon. Thank you.

[@SabrinaLumina]

Why when I run, it send 2 emails? 1 with the attachment pdf & another one attachment with excel which we used for list rows present in a table.

[@technologiate]

Hi, this can happen if you keep the Excel file in the same folder where you saved the attachments. Can you try moving the Excel file to a different location? It should work.

[@SabrinaLumina]

@@technologiate thanksssss it works!

[@technologiate]

@@SabrinaLumina You are welcome

[@jentrh]

im having problems with contacts part. it says action failed

[@technologiate]

Hi, are you using a Microsoft 365 account or a free account?

[@jentrh]

@@technologiate im using a microsoft 365 account

[@jentrh]

maybe it’s because the attachment i want is an excel file and not a pdf one

[@technologiate]

@@jentrh It works with any type of file type.

[@technologiate]

If you are having an issue with reading the contacts table, make sure you are using the correct action for the business account. Also, sometimes, it can not read the data for some Power Automate issues. Close the Power Automate windows and try again in that case.

[@nandycisco9391]

Excellent, Followed the same but i got below error while i clicked "save button" Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The repetition action(s) 'Contatcs' referenced by 'inputs' in action 'Send_an_email_(V2)' are not defined in the template.'.'.

[@technologiate]

Hi, did you rename the loop, as I explained at 04:14 ?

[@nandycisco9391]

@@technologiate Yes i did.. getting below in contacts Add to each ActionFailed An action failed. No dependent actions succeeded.

[@technologiate]

@@nandycisco9391 Can you send an email of the flow and a screenshot of the error?

[@HarinderSingh-qr4hh]

Only sending 250 per office 365 id, you cant send in bulk in cc