We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

How to send multiple excel files to the email as attachments?

Comments

3 comments

  • Avatar
    Adrian Williams

    I think you pretty much have it.

    In this example the file names are in the FileName field. Note that in the FilesToAttach property there are no apostrophes around the name and (as you mention) the 'from Field' source option is used.

    However, this configuration will send a separate email for each input record and the email will contain the file specified in the FileName field.

    If you want to send multiple attachments in a single email then you need to concatenate the filenames into a semicolon-separated list.

    You can use a Transform node to perform the concatenation of the strings:

    The Send Email node would be configured similar to the previous example but the FileNameList field would be the source of the files to attach.

    See the attached example (required Data360 Analyze v.3.6.x)

     

    Attached files

    Send_Email_with_Attachments--share - 28 Apr 2021.lna

     

    1
    Comment actions Permalink
  • Avatar
    Himangi Nashine

    Hello Adrian,

    Your approach is very insightful and helpful.

    I tried it with my files but I am getting an error of File not found.

     

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    There appears to be something wrong with the path - there are no path separators shown in the error message. 

    Check the output of the Create Data node to confirm the strings are correct. When defining strings in the Create Data node you have to escape backslash characters (\) as used in Windows-style paths e.g.

    0
    Comment actions Permalink

Please sign in to leave a comment.