MailSteward

MailSteward™

Contents:
Links:
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.
  • keywords or phrases in the From address.
  • keywords or phrase in the To address.
  • keywords or phrase in the Subject line.
  • keywords or phrase in the Body text.
  • text strings in the Mailbox name.
  • text strings in an attachment file name.
  • text strings in attachment contents, if the attachment contains unencoded text.
  • text strings in the raw headings of the email.
  • a text string anywhere in the email in any of the fields.
  • tags - category, keywords, priority.
  • attachment types, such as graphics, documents, video, etc.
  • Or, if you know SQL, by editing the SQL statement generated by MailSteward.
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. If an email has both plain text and HTML versions, the HTML version will appear in the body text panel, and the plain text version can be viewed by clicking on the Text button on top of the main window. 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 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.



TM & Copyright © 2004-2025 pubblog.com. All rights reserved.