Testimonials

"Over the years Gammadyne has become a mission critical piece of software to our operations."
- David Goodale

"Finding Gammadyne Mailer was like a dream come true for us."
- Jonathan Deitch

"Gammadyne is absolutely the BEST bulk email solution out there."
- Cindy Papenheim

Email Data Extraction

The following guide explains how to configure a Gammadyne Mailer project to process data in an incoming email, and add that data to a new row of a database.

Go to the Database branch. Specify the name of the ODBC Data Source, the Table Name, the Recipient Column, and the Primary Key. To see more information about these fields, right click on the editbox and choose "Help".
Go to the Incoming/Source branch. Check the "Process Remote Email" box. Click the "Add" button at the bottom of the table. Specify the details of the incoming email account (server name, protocol, port, user name, password).
Go to the Incoming/Processing branch. Set the Processing Mode to "Add to database". In this mode, when an email is received, a new row is added to the database. The email address will be automatically added to the Recipient Column (specified on the Database branch).
Check the "Process From:" box. The email address that is stored in the Recipient Column will be taken from the From: header of the incoming email.

On the Incoming Script branch, you can write a script that will extract other data from the email body, and store that data in the new database row. Consider the following email body:

Name:John Public
Age: 36
Gender:M

To process this kind of message, the script would look like this:

[[let name = latch(-Body-, "Name:")]]
[[let age = latch(-Body-, "Age:")]]
[[let sex = latch(-Body-, "Gender:")]]

In this example, "name", "age", and "sex" are the names of database columns.

Completion

Now that the project is finished, choose "Save Project As" on the File menu to save the project. Send a test email to the email account. Then launch an Incoming Operation by pressing F7. If the row is not added to the database, examine the Incoming Log for error messages (press F10).

Once testing is completed, go to the Incoming/Processing branch and change Delete Messages to "When Processed". This ensures that an incoming email is only processed once.

Although this example demonstrates the most common type of email data extraction, many other ways of processing email data are possible. The G‑Merge scripting language is capable of handling almost any conceivable scenario. For more details, please refer to Gammadyne Mailer's help file. And let us know if you need assistance.