DB for Outlook™ provides Microsoft® Excel and Microsoft® Outlook users to execute the following functionality at ease:
- To build a directory of all Outlook folders
- To process all e-mails within selected folders to build an Excel database automatically.
- To send simple, RTF or HTML e-mails automatically to all selected recipients
- Use the program to send and collect question and answer and create results instantly.
These functionality are summarized in the following sections:
Assuming that you have Microsoft® Outlook installed on your computer as default e-mail, DB for Outlook™
will generate the listing of all folders in a Excel workbook as shown below.
Suppose you are interested in building a database from the incoming emails that have the following properties:
- The subject is labeled as "Course Evaluation"
- There are number of fields where the field name is separated from the answer by ":"
- All email are in your Input folder.
The above information is entered in the Command to Process E-Mails data entry as shown
The Input folder within the Personal folder is selected by placing an X in the column A.
Finally the database is generated by clicking the following button.
The following worksheet will be generated.
Once the data is gathered in the Input Database worksheet, a set of e-mails can be generated automatically. To do so, the following information are needed:
| What | For example | |
| Column in which the e-mail address appears in the Input Database worksheet. | A | |
| Column in which the Name appears in the Input Database worksheet | I | |
| The subject of the e-mail. | Thanks for Evaluating Our Course | |
| Output Database Default Path Name | C:\DB for Outlook | |
| Output Database Default WORD File name | ||
| Output Database Default HTML File name | Thank you.htm |
The database is generated by clicking the following button.
Reviewing the E-mail list, you observe that john doe is not a real name,
you add this e-mail to the remove list worksheet.
Click the Check Remove List button, the program automatically adds the Remove List in from of John Doe name and let you know that Leo Two has entered the form twice.
After review the Output Database worksheet, enter the word Send in the status column of the worksheet. Then click the Send E-Mails button.
The following e-mails is constructed and is ready for you to click the send button.
