0

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?

0

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:

| improve this answer | |
  • Thanks Markus! Just to confirm that I will need to create a new email with the above AMP script included. Correct? – Ben Bakos Sep 1 '17 at 13:53
  • Yes, that is correct! – Markus Slabina Sep 2 '17 at 2:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.