# MailSteward Pro™

Contents: Home Installing MySQL© Connect to MySQL© Server Federal Legal Requirements Settings Archive Email Search Email Indexing for faster searches Browse Email Schedule Archive Tags Back Up Your Database Export... Import mbox files... Import MailSteward SQL file Check for Duplicate Email Database Statistics Report... System Requirements Links: MailSteward Request a feature Submit a Bug MySQL© MailTags© Sequel Pro CronniX | Search Email: Once your email is in the database, it can be retrieved by specifying any combination of: A range of beginning and ending dates. A keyword or phrase in the From address. A keyword or phrase in the To address. A keyword or phrase in the Subject line. A keyword or phrase in the Body text. A text string in the Mailbox name. A text string in an attachment file name. A text string in attachment contents, if the attachment contains any text. A text string in the raw headings of the email. A text string anywhere in the email in any of the fields. Tags - category, keywords, priority. Or, if you know SQL, by editing the SQL statement generated by MailSteward Pro. If the only email with attachments check box is checked, then only email with attachments will be retrieved. If an email has attachments or an HTML or enriched text version that has been saved in the database, a list of the attachments will appear at the bottom of the email text as a blue, underlined link beneath the title ATTACHMENTS:. Clicking on the link of an attachment will allow you to launch the attachment using the default application for the type of file, or save the attachment as a file. The number of attachments for each email appears in the ATCH column. 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 icon you can refine your search by doing a search within the current search results list. If you click on the View raw source icon , a separate window will open containing the raw source of the selected email with all of the original header information. Click on the Reply icon, , 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. 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. If you click on the Advanced button, it will bring up the Advanced Search window which will allow you to add additional ANDs or ORs to any of the fields or tags. In the first example above, the Search will return all of the emails both from and to Joe Smith that have the word "contract" in either the body of the email or in any documents attached to the email. If you also want to check for emails from and to Kathy Connors, and you also want to find emails that contain the word "invoice" in the body or in the attachments, you can do this in the Advanced Search: This will generate an SQL statement that will return all of the emails either from or to Joe Smith or Kathy Connors that contain either the word "contract" or "invoice" in either the body of the email or in any attached documents. 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 Pro database structure.

TM & Copyright © 2004-2009 pubblog.com. All rights reserved.
MySQL is Copyright © 1995-2009 MySQL AB. All rights reserved.
MailTags is Copyright © Scott Morrison.