Linking to a data source

eMill seamlessly interacts with Microsoft Access, Excel files, Outlook Address Book, Windows Address Book, ACT! 2000, and automatically generates the connect string and SQL queries to acquire the database fields. When using another format the data link properties box is displayed to help you generate the connect string.

Starting a new project, check either one of the following options:

Excel Spreadsheet (.xls)
Access Database(.mdb)
Windows Address Book (.wab)
Outlook Contacts
Text Files (.txt, .csv)
If requested, from the data source selection box, supply the path to your file, or click on the adjacent button to browse for it:

eMill will retrieve all the tables and queries (stored procedures) from the database, and displays them in the Tables/Queries window:

Select a database table/query to visualize its fields. Highlight the fields you need for your project: Click on the fields holding down the CTRL key down for multiple selections. Selecting * will generate the query that acquires all fields of the table. According to the communication channel you want to use (email and/or fax and/or SMS), you need to select a field with email adresses, fax or phone numbers.
If requested, make the field associations for information used inside the message headers. Clicking on the scroll down lists should present you with all fields you have acquired. According to the communication channel you want to use (email and/or fax and/or SMS), you need to associate the email, the fax and/or the SMS field with their database equivalent.

SQL Query generator: Highlighting the database tables/queries and available fields generates the SQL query to acquire the data. You can however edit and enter any SQL query and bypass eMill's generator.