Contents:
|
Search Email:
Once your email is in the database, it can be retrieved by specifying any combination of:
Binary attachments, like graphics, sound files, Word documents, or PDF files, are stored in their original binary format. Any attachments that contain text, such as Word documents, can be searched. However, the text in PDF documents is encoded such that it cannot be searched. Clicking on the drop-down menu next to the mailbox field will display a list of all the unique mailboxes in the database. Clicking on one of the mailboxes in the list will place it in the mailbox search field. Clicking on the Reset button will set all of the search criteria back to the default. Once the search is done and the email has been retrieved, you can click on the header of any column to sort in ascending or descending order. If you click on the Search List button you can refine your search by doing a search within the current search results list. If you click on the View Raw Source item in the Window menu, a separate window will open containing the raw source of the selected email with all of the original header information. Click on the Reply button to reply to the selected email. The OS X Mail application will be launched and an email message window opened, with the From, To, and Subject information filled in, and the text of the message being replied to, inserted in the body.
Each of the field label drop-down buttons can be changed to a different field label. So you can search for multiple keywords or phrases in the same field. You can also drop down the buttons to the left of the field labels to select AND, OR, AND NOT, or OR NOT. The above search criteria will generate an SQL statement that will return all of the emails either from or to Joe Smith that contain either the word "contract" or "proposal" in the body of the email or the word "contract" in any attached documents. Also only emails with attachments will be retrieved. If you click on the choose attachment types to search button, a sheet will appear where you can choose attachment file types grouped as graphics, documents, sound, video, and/or compressed.
If you have tagged some of your email, you can do a search based on your tags, and you can also combine the two and do a search that includes both fields and tags. Clicking on the drop-down menu next to the Keywords field will display a list of all the unique Keywords in the database. Clicking on one of the keywords in the list will place it in the Keywords search field.
Clicking on the Saved Searches button brings up a window to let you save a set of Search criteria, or execute a previously saved Search.
If you click on Set Browse Button, the currently selected saved search will be made the default for the Browse button. Whenever you click on the Browse button, this search will be executed instead of listing all of the email in the database. If you click on Reset Browse Button, the default for the Browse button will be reset back to listing all email. Clicking on the Edit SQL Statement button will bring up the following window, which allows you to add parentheses or NOTs, or enter your own SQL.
Clicking on the Show Database Schema button will display a complete list of the tables and field names in the MailSteward database structure. |