Email

Parent Previous Next


Email Source


The Email Source allows you to setup the properties to read messages from a POP3/IMAP mailbox. You can setup filtering for the data coming in from the mailbox to prevent unwanted messages or to target specific messages. See the Email Connection Manager page to learn more about setting up the connection manager.



 Email Connection - Choose and existing Email Connection Manager or select "Create New Connection"

 Attachments Directory - The attachments directory is where any attachments for email messages will be stored. Each attachment will be stored in a separate directory to avoid collisions. The location of each attachment is stored in the "Attachments" column of the Output.

 Messages Variable - The messages variable is an object variable that can be used by the "Delete or Move Messages Task" which allows you to delete messages that we retrieved in the email source.

 Columns

o   Column Name - All email source adapters include the following fields to be used by your package

  Body - The plain text version of the email

  BodyHTML - The HTML version of the email

  Subject - Subject of the email

  FromEmail - Email address only of the person who sent the email

  DateSent - The date the email was sent

  To - Email address of the account the message was sent to

  Size - The size in bytes of the message

  Priority - The priority of the message

  Attachments - The attachments of a message

  RelatedItems - The items embedded into a message. Usually images in message footers.

o   Filter - The Email Source allows you to filter the data coming in from the source mailbox. There are different filters allowed for different data types.

 String Columns - Allow Contains, Equals, Ends With and Start With filters.

 Integer Columns - Allows Greater Than, Less Than, and Equal filters

 Data Columns - Allow After and Before filters

 Condition Textbox - Here you can use variables to use with filtering


Column Filtering


The Email Source allows you to filter the data coming from the source mailbox using simple expressions. There are different filters allowed for each data types:


 String Columns - Allows for the usage of the Contains, Equals, Ends With, and Starts With filters

 Integer Columns - Allows for the usage of the Greater Than, Less Than, and Equals filters

 Date Columns - Allows for the usage of the After and Before filters


Additionally, filters allow for the use of variables within the filter's condition textbox. This can be done by appending two ampersats (@@) to the front of the variable name. For instance, the variable named "strFromEmail" could be applied to the "FromEmail" column in the following manner:



After the filters are set, each row that contains a filter will turn green and display a pseudo-select statement that allows for a quick view of all of the filters that are set within the Email Source.