KNIME Send Email from File Server Location

[aehrenworth]

I am struggling with trying to piece together a use case using Send Email node and the SMB connector and a variable loop to create an Excel file with multiple dynamic tabs.

What I want to do is what for the loop to be complete and then copy the final version of the Excel file to a tmp location on the Business Hub so that it can be successfully attached to the email.

I can’t use the SMB connector for the Send Email node, so that is the thing I need to work around.

Any suggestions? There are credentials embedded in the flow so I can’t share it on here.

[hotzm]

Hi @aehrenworth,

you could check out the Email Sender node, which supports attachments in the form of a table of Path cells. You can pass your final Excel file similar to here:

It should work with paths on the SMB filesystem, too.

Let me know if it helps!