Sample Message - Update Message Filter and Reload

Arclab® Inbox2DB

If the wrong Sample Message has been loaded ...

Inbox2DB loads the newest message matching the selected message filter from the specified IMAP/POP3 mailbox.


If you have not setup a message filter or the message filter is not correct then it's possible that the wrong sample message has been loaded:


Wrong Sample Message


In this sample the subject is: OTHER MESSAGE ...
The program has downloaded the wrong message because there was no filter setup.


It's important to setup a message filter to ensure that no other messages will be processed. Please setup a filter even if there should be no other messages on the account - it's always possible that e.g. a spammer sends a message to the email address!

Edit the Message Filter


Click on "Cancel" to close the "Edit Column Relationship" screen:





Click on "Edit" to change e.g. the "Data Connection Source" > "Subject Include Keywords":


Edit Subject Include Keyword

What Filter should I use ?


Please use your normal mail client (e.g. MS Outlook), locate the correct message and take a look at the "Subject" and "From" (sender).


In our sample all messages which should be processed have the subject: Order Notification followed by a number, e.g.

Subject: Order Notification #345398754

The number is different for each mail, so we only use "Order Notification" as "Subject Include Keyword".

This means the program will process all messages with the keyword/phrase  "Order Notification" in the subject. The keyword/phrase can be at any position inside the subject, so it would also work if the subject would be: "#345398754 Order Notification"


In our sample all messages are sent by the same sender, e.g.


Use e.g. "" as "Sender Include Keyword" to include a single sender or "" to include all sender from the domain.

Only use the "Sender Include Keyword" if all messages (which should be processed) have the same sender.



Setup Message Filter


Click on "Ok" to close the dialog after you have setup the message filter.

Reload the Sample Message


Scroll down to "Data Connection Settings" and click on "Edit Relationship":


Edit Column Relationship



The program automatically reloads the "Sample Message" if you clicked on "Cancel" on this screen before ...
otherwise you need to click on "Reload Sample Message" to reload the message:


Reload Sample Message


The program has now loaded the correct sample message:

  • The "Sender Include Keyword" is included in the "From:"
  • The "Subject Include Keyword" is included in the "Subject:"


The program auto-detects matching fields if the field names ("Target Columns") taken from the target database ("Data Connection Target") are available in the sample message, e.g.

Name: Value

Name= Value

Name : Value

Name = Value


If the program has not detected matching fields (e.g. if the field names are different) setup the "Column Relationship" as described here.