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

Поділитися
Вставка
  • Опубліковано 4 лис 2024

КОМЕНТАРІ • 28

  • @technologiate
    @technologiate  3 місяці тому +1

    *Mail Merge without attachments using Power Automate:* ua-cam.com/video/ItrVEQCwKW0/v-deo.html

  • @sagarpatel1252
    @sagarpatel1252 14 днів тому +1

    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!

  • @TimothylynchRoss
    @TimothylynchRoss 3 місяці тому +1

    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
      @technologiate  3 місяці тому

      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

  • @FauziaRehman
    @FauziaRehman 2 місяці тому

    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
      @technologiate  2 місяці тому +1

      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
      @FauziaRehman 2 місяці тому

      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?

  • @tonytseng7780
    @tonytseng7780 2 місяці тому

    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
      @technologiate  2 місяці тому

      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.

  • @SabrinaLumina
    @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
      @technologiate  Місяць тому +1

      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
      @SabrinaLumina Місяць тому +1

      @@technologiate thanksssss it works!

    • @technologiate
      @technologiate  Місяць тому

      @@SabrinaLumina You are welcome

    • @SabrinaLumina
      @SabrinaLumina 21 день тому

      @@technologiate why it send 2 emails? 1 to me and another 1 to the correct email? I didn’t input CC & is there any demo if we want to input 2 attachments in 1 email?

  • @nandycisco9391
    @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
      @technologiate  Місяць тому

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

    • @nandycisco9391
      @nandycisco9391 Місяць тому

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

    • @technologiate
      @technologiate  Місяць тому

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

  • @HarinderSingh-qr4hh
    @HarinderSingh-qr4hh Місяць тому

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

  • @jentrh
    @jentrh 2 місяці тому

    im having problems with contacts part. it says action failed

    • @technologiate
      @technologiate  2 місяці тому

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

    • @jentrh
      @jentrh 2 місяці тому

      @@technologiate im using a microsoft 365 account

    • @jentrh
      @jentrh 2 місяці тому

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

    • @technologiate
      @technologiate  2 місяці тому

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

    • @technologiate
      @technologiate  2 місяці тому

      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.