The Email Table Loader component allows emails to be read from disk and loaded into a Table.

The component reads emails stored on disk in the standard RFC822 format, each message in a separate folder, with any attachments already MIME decoded and stored individually.

You can use any software to prepare these files, which can receive emails by SMTP or POP3, and write them out to disk in the required format (Separate / Parse Attachment Format ).

---

Instead: directly import using POP3

You can import emails and attached files directly into Tables by POP3 collection by using a Table 'Email Collection' Action triggered by a scheduled Event.

Discover how to directly import email by collection here...

---

When the Email Table Loader has loaded an email, the source files are deleted from disk. This prevents the disk from filling up with historic files, and prevents the operating system stalling (Windows does not happily handle large numbers of files in a directory)

The Email Table Loader is configured by selecting two Tables: one for the Email itself, and one for any attachments. When an email is loaded, a record is created in the first Table, and if there are attachments, it will create a record for each attachment in the attachments Table.

In configuring the Email Table Loader, you need to specify which field in each form should receive the various parts of the email.

In the Behavior Editor you select the location on the disk where the email will be loaded from, and a schedule for when it should start the loading. Typically every few minutes.

When the Email Table Loader creates a record the Record Change event for that Table is triggered. So for example you could create a notification email to be sent out if an email was loaded that matched some criteria. Be careful to avoid creating message loops, where the email generated also gets loaded in by the Email Table Loader, triggering another email, etc.

---

Using a trial or cloud server?

The Email Table Loader component is designed for enterprise deployments where you are in control of your own dedicated server (which may be local or in the cloud). However if you are using a shared cloud server managed by another organisation, or are trialling the software on a cloud trial, you may not be able to use this component without assistance from the server manager, since the process involves direct access to the server storage volume and the configuration of external software.

---