Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm currently sending emails through the Data Load Editor via SMTP / Notification Connector .
Now I wanted to attach Excel / CSV files to that emails. Unfortunately, I couldn't figure out how to do that.
Has anyone an idea how to attach files to emails and send them out via the Data Load Editor?
That's the code where I tried to implement the attachment:
LET vDefaultFromName = 'NoReply';
LET vDefaultFromEmail = 'jd@email.com';
LET vAttachment = "lib://PathToExcelFile.xlsx";
SUB SendMail(vsndm.force, vsndm.to, vsndm.cc, vsndm.subj, vsndm.msg)
SendMailLog: LOAD * INLINE [DateTime,EmailHash];
LET vHash = Hash256(vsndm.to, vsndm.cc, vsndm.subj, vsndm.msg);
IF FieldIndex('EmailHash', vHash) = 0 OR vsndm.force THEN
LIB CONNECT TO 'REST Email Connection';
RestConnectorMasterTable:
SQL SELECT "status", "result", "filesattached"
FROM CSV (header on, delimiter ",", quote """") "CSV_source"
WITH CONNECTION (
QUERY "to" "$(vsndm.to)"
,QUERY "cc" "$(vsndm.cc)"
,QUERY "subject" "$(vsndm.subj)"
,QUERY "message" "$(vsndm.msg)"
,QUERY "fromName" "$(vDefaultFromName)"
,QUERY "fromEmail" "$(vDefaultFromEmail)"
,QUERY "fileAttachment" "$(vAttachment)"
,QUERY "format" "csv"
);
LET vWasSent = Peek('status', 0, 'SendStatus');
DROP TABLE RestConnectorMasterTable;
ENDIF
END SUB