web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Mail merge with unique...
Power Automate
Answered

Mail merge with unique attachment in desktop version

(0) ShareShare
ReportReport
Posted on by 22

I have been trying to create a workflow for mail merge with unique attachments in Power Automate Desktop. I have an excel list of email ids.  And all the files in a folder. Please help. I am new to this.

  • fraenK Profile Picture
    2,125 on at
  • rajat281293 Profile Picture
    22 on at

    Getting this error.

     

    Robin.Core.ActionException: Failed to send email message ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.InteropServices.COMException: Outlook does not recognize one or more names. --- End of inner exception stack trace --- at System.RuntimeType.InvokeDispMethod(String name, BindingFlags invokeAttr, Object target, Object[] args, Boolean[] byrefModifiers, Int32 culture, String[] namedParameters) at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams) at System.Type.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args, CultureInfo culture) at Robin.Modules.Outlook.Actions.OutlookActions.InvokeMethod(Object o, String methodName, Object[] methodArgs) at Robin.Modules.Outlook.Actions.OutlookActions.SendEmailThroughOutlook(Variant outlookInstance, Variant account, Variant from, Variant to, Variant cc, Variant bcc, Variant subject, Variant body, Variant attachments, Boolean isBodyHtml, Int32 sendEmailFrom) --- End of inner exception stack trace --- at Robin.Modules.Outlook.Actions.SendEmailThroughOutlook.Execute(ActionContext context) at Robin.Runtime.Engine.ActionRunner.RunAction(String action, Dictionary`2 inputArguments, Dictionary`2 outputArguments, IActionStatement statement)

  • fraenK Profile Picture
    2,125 on at

    Might be caused by the recipient address? If you get that from Excel, try to use trim before to remove whitespaces.

  • rajat281293 Profile Picture
    22 on at

    I don't think so. I used VBA coding for the same. It worked fine through that excel. 

  • fraenK Profile Picture
    2,125 on at

    PAD is not VBA 😉

  • rajat281293 Profile Picture
    22 on at

    rajat281293_0-1618682709722.png

    This is how I extracted all my data from different columns into list such as To sent, cc, subject, document path. 

  • rajat281293 Profile Picture
    22 on at

    Did that. Still same. Have a look at the screenshots I posted in this comment and others. 

    rajat281293_0-1618683521834.png

     

    rajat281293_1-1618683581660.png

     

  • fraenK Profile Picture
    2,125 on at

    the error comes from the send email action

  • rajat281293 Profile Picture
    22 on at

    yes. I reduced my email list to just 1 line. It worked fine. There is something wrong with the way I am extracting my data from excel I guess

  • fraenK Profile Picture
    2,125 on at

    You are sending to a list variable, which values are separated by comma. Outlook recognizes semicolon by default.

    Do you really want to send one single email to all recipients? Otherwise you need to go through every row of your columns. 

    %ExcelData[rowNumber]['ColumnName']

    https://docs.microsoft.com/en-us/power-automate/desktop-flows/variable-data-types#advanced-data-types

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 227 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 221 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 132

Last 30 days Overall leaderboard