0

  1. I have an incoming zip file containing multiple csv files. I extract and run an automation activity on a specific file name pattern, this is the master data file containing which file goes as an attachment to which email address.

  2. once this master data is loaded in Data Extension, I use the Send Email activity to send the email with attachment.

To Do

  1. How do I send an email only if the file to be attached is present in the import folder ? (otherwise the email still sent without attachment)

Can I ?

  1. Is there an AMPScript to skip an activity to be carried out ?
  2. Can I write a SQL activity to verify if a file exists ?
Improve this question

1 Answer 1

Reset to default
1

The standard functionality of AttachFile function is to throw an error if a file specified in AttachFile function cannot be found.

NOTE: If the specified file cannot be found at send time, the send will throw a runtime error and abort.

Source

You might want to contact Salesforce to adjust this error behaviour, as sendtime errors come in two flavours:

  • Prevents only this specific email from being sent, while continuing the send job
  • Stop both the current email, while also cancelling the rest of the send job

You obviously want to ensure, the setting is giving you the first option.

You can also contact your account executive to adjust the error threshold that causes the send job to stop prematurely. This feature helps prevent a single error from stopping the entire job.

Source

Improve this answer
1
  • Thank you Lukas. Commented May 17, 2024 at 14:56

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.