Link to an external Database Source

AY Mail 2. Professional and Corporate Editions

If you keep your recipient data in a database, you can create AY Mail project which is linked to your database. AY Mail will only pull the list of recipients from the database every time it sends, so all the changes in your database will be automatically reflected in AY Mail sendinds. You do not have to worry about synchronizing recient list in AY Mail with your database.

You do not necessarily need to use a database - you can use files, mail folders, address books, etc.

You can use nearly all AY Mail features with projects linked to external data sources - you can do searches, preview your messages, use any of the database fileds for mail merge and personalization, you can use groups to restrict your mailing to only a part of the database.

When a linked project is loaded into AY Mail, you will not see addresses on the Recipients tab. Rather, you will see the description of the data source. The recipients may be pre-loaded and viewed using buttons on the Recipients tab.

To avoid frequent loading of database data, AY Mail keeps the database in your computer memory once they're loaded. For example, if you preview your message, then look at the recipients, then send, the data will be retrieved only once. By default, AY Mail keeps the data ready for 3 hours, but you can extend or shorten this period.

You can change the link to point to other source, but only if the set of data fields in both places is compatible.

After you do a mailing, you can export the report, which will create a CSV file with all the status and click through information. You can use this file to put this information back to your database.