[SalesForce] Emailing a file from Enhanced FTP using Automation Studio

I have an automation in place that exports data from a data extension and then uploads the file to our FTP account.

Is there was a process within Automation Studio to have that file emailed as an attachment?

Best Answer

There is no default way to do so. However sending a file from the Import-folder of your Enhanced FTP is possible. Attaching csv-files isn't allowed for some reason, which is rather strange as this is the default format for exporting a data extension. Therefore further processing could be necessary in your case.

But basically adding a File Transfer Activity that moves the exported file from the Export to the Import directory on your Enhanced FTP would be necessary if the file doesn't reside in the Import directory already (which it will if you upload the file from an external system).

As soon as the file is placed in the correct folder you can add a Send Email activity that makes use of the AttachFile AMPscript function.

%%=AttachFile('FTP', 'nameOfTheFileOnFTP.xls', 'nameOfTheFileInEmail.xls')=%%

Related documentation:

Related Topic