"Over the years Gammadyne has become a mission critical piece of software to our operations."
- David Goodale
- David Goodale
"Finding Gammadyne Mailer was like a dream come true for us."
- Jonathan Deitch
- Jonathan Deitch
"Gammadyne is absolutely the BEST bulk email solution out there."
- Cindy Papenheim
- Cindy Papenheim
Gammadyne Mailer Database Support
Gammadyne Mailer offers an internal database for holding your mailing list. You are free to create as many tables, and columns, as you like. But it can also integrate directly with an existing third-party database. All ODBC-compliant databases are supported, including Access, Act!, Centura SQLBase, dBASE, Excel, FileMaker, FoxPro, MySQL, Oracle, PostgreSQL, and SQL Server. It can also connect to many CRM databases.
Database integration has many advantages, including:
Database integration has many advantages, including:
- Use your existing data directly. No importing is necessary!
- Outgoing emails can be personalized with database data.
- Data from incoming emails can be extracted and added to the database. This is very useful for automating mailing list sign-ups, processing form data, etc.
- Searching and removing recipients is much faster with a database than a simple file (provided that the email address column is indexed).
- List segmentation (see below).
Is a database required?
A database is not required. Gammadyne Mailer can send to a list of email address in a plain ASCII text file, which looks like this:
It can even merge in data from a comma-separated text file (.CSV), which looks like this:
jpublic@foo.com
jane@bar.com
jsmith@foobar.com
It can even merge in data from a comma-separated text file (.CSV), which looks like this:
id,name,email,age
1,John Public,jpublic@foo.com,26
2,Jane Doe,jane@bar.com,30
3,Jim Smith,jsmith@foobar.com,28
Integration Details
Gammadyne Mailer connects to an external database via ODBC (Open Database Connectivity). This is a Microsoft standard that is designed to allow any application to talk to any database.
Because Gammadyne Mailer is a 32‑bit application, it requires the 32‑bit ODBC driver, even if your operating system is 64‑bit. If you don't see the driver in the list, go to the database vendor's website and download and install their 32‑bit ODBC driver.
Click here to watch a video tutorial on how to integrate Gammadyne Mailer with a database.
In brief, go to the Database branch, check the "Use Database" and "Use Connection String" boxes. Click the "Browse" button next to the Connection String. This window will appear:
Choose the appropriate driver for the database. If you don't see it, it's because the 32‑bit ODBC driver is not installed. Click OK and an ODBC Setup window will appear, similar to this:
Click the "Select" button. An "Open File" dialog will appear, where you can then navigate the hard drive or network to find the database file. Once the database file is selected, click OK and the Connection String field will be populated. You are then ready to fill in the table and column names.
Because Gammadyne Mailer is a 32‑bit application, it requires the 32‑bit ODBC driver, even if your operating system is 64‑bit. If you don't see the driver in the list, go to the database vendor's website and download and install their 32‑bit ODBC driver.
Click here to watch a video tutorial on how to integrate Gammadyne Mailer with a database.
In brief, go to the Database branch, check the "Use Database" and "Use Connection String" boxes. Click the "Browse" button next to the Connection String. This window will appear:
Segmentation
The mailing list can be segmented or filtered according to the contents of any database column. This allows you to send to a select group of recipients. Segmentation is accomplished by specifying one or more requirements on the Clauses branch, as seen in this screenshot:
