Skip to end of metadata
Go to start of metadata

Email messages can be automatically sent upon the completion of an operation. You can create success or failure notifications. Email Messages can also be used as an argument to the SendEmail method.

Follow these steps to create notifications:

  1. Make sure you have opened the appropriate project in which you want to create the new email message.

  2. Create and test an operation.

  3. Right-click on the Email Messages node in the Project Tree and choose New Email Message or click create new email message on top toolbar. A new tab entitled "New Email Message" will appear in the right pane.
  4. Fill in the properties of your message:

    1. Message Name: The name of your message, which must be unique within your project.

    2. SMTP Mail Servers (required): Comma separated list of SMTP servers that you want to use to send your email. The servers will be tried in the order that they are specified until one is found to accept the message.

    3. To: Comma separated list of recipients.

    4. From: The email address that you want to appear in the "From" field when the recipient(s) read the email.

    5. Use SSL/TLS (optional): Click the checkbox to encrypt the email using SSL/TLS protocol.
    6. Authentication (optional): If your SMTP server requires authentication you must expand the Authentication fields and check the "Use Authentication" check box. You can then enter an Account and Account password.

    7. Optional: If you expand the Optional fields you can add CC, BCC and Reply To addresses. The addresses in the CC field will receive a copy of the message, the ones in the BCC field will get a blind copy of your message. The Reply To address is the one you want replies to be sent to by default (i.e. when the recipient presses reply). This can be used if you send the email from a common account but you want replies to go to your personal email inbox.

    8. Subject: The subject of the email.

    9. Text: The body of your email

    10. Note All of these fields recognize global data element substitutions. E.g. if you don't know who the recipient will be until you have run your operation you can set a global data element called "notify_email" during the transformation (e.g. using a DBLookup or input data) and then enter [notify_email] in the To-field.

    11. Click the Save icon in the toolbar in the upper right corner to save the email.
  5. Once you specify the properties for your email message, you must associate the Email Message with one or more operations.

  6. In the Project Tree, Click on the operation that you want to add a notification message to; its properties will be displayed in the right-hand pane.

  7. Expand the Options drop-down menu by clicking the at the top of the Operation graphic.

    1. From the drop-down menu Select On Success or On Failure.

    2. From the side-bar menu Select Email.
    3. From the side-bar menu Click Select Existing.
    4. A pop-up window displays the list of existing email messages. Select the Email created in the previous step from the list and Click OK.
  8. The Email will be added to the operation graphic with a green arrow if you selected to send On Success, or a red arrow if you selected On Failure.
  9. Deploy your project.

NOTE:

Dynamic parameters like "[date]" do not work in Subject or Text. In Jitterbit Studio, date() is defined as a function.  If you would like to pass date as a variable, you could create a variable in a script and assign it a value, then pass it in your email message.

Ex: $date = Now()   would give you the current date and time

$date = CVTDate(Now(),"yyyy-mm-dd HH:MM:SS","yyyy-mm-dd")      would give you just the date