E-mail to Database

TeamDesk offers the capability to directly accept emails into a database. The "E-mail to Database" functionality proves useful when you need to automatically process email data to either create new records or update existing ones.

It’s important to avoid creating references to the "Mailbox" table, as the content of the "Mailbox" will be periodically cleaned up (records are automatically deleted after 30 days).
The table is read-only therefore, data cannot be changed or deleted in any of the columns.
Additionally, please note that the system imports new emails approximately every 3-5 minutes, so there might be a short delay within this interval.

To enable the "E-mail to Database" feature, follow these steps: Click on Setup > Database tab > Tools section > E-mail to Database link.

As a result, a unique E-mail Address will become associated with your database. This address can be utilized in the "To," "CC," or "BCC" email fields. You can also set up email forwarding to this address.

If you need to use an email from your own domain, please set up a mail forwarding rule on your mail server that will forward the email to your TeamDesk email address.

The Security Token adds an extra layer of security. If your email address becomes compromised by spam, you can change the token to mitigate the issue.

All incoming emails will be stored in a dedicated "Mailbox" table, which will be automatically added to your database.

Application Id

This column stores the database Id number.

Sent

Date and time when an email was sent.

Priority

Email priority.

Tags

You can use a sub-address to convey information to TeamDesk while keeping it hidden from the user who receives the notification. For instance, if you include the {appid}[.token]+tags@mail2db.teamdesk.net address in the Bcc: field or set up forwarding to this address, the system will populate the "Tags" column in the "Mailbox" table with the value from the tags (sub-address).

Subject

Email subject.

Body

Email body.

From, To, CC

These columns hold the values of the From, To, and CC addresses respectively.

Attachment

If an email contains up to 4 attachments, they will be stored in the Attachment 1, 2, 3, and 4 columns.

Error

Any errors that arise during email processing are meticulously logged in this column.