| More


Click here to subscribe
to our weekly newsletter
Exchange Messaging Outlook

EMO back issues






Adding Extended MAPI Fields to Outlook

How to show the sender’s e-mail address and other fields in a column in message list view

 

Many Extended MAPI properties are added to messages when they are committed to Outlook message store or the Exchange mailbox but Outlook doesn't have a built in way to expose the value. It's possible to write a configuration form that exposes the value in a custom field.

Below are configuration files that expose the Sender ID, SCL (spam confidence level) and sender's email address in the message list and instructions on installing them in Outlook. If the SCL form doesn't seem to install in Outlook 2007, see Troubleshooting below.

Added July 26 2007: 'Replied to' Time. Use this to display the time the 'last verb' executed. This will be the time it was replied to or forwarded.

Added August 7 2008: Extended-Properties. Along with the Sender's email address and Replied to time, the Internet Message ID is also exposed.

Note:
 Sender ID only works with Exchange 2003 SP2
 SCL requires Exchange 2003's IMF

CFG Files | Install CFG | SenderID Labels | Replied Time

CFG files

If you'd rather not create your own CFG file, even though it involves only copying text from a web page and pasting it into notepad, the following ready-to-use CFG files are available for download. (Right click on the links and choose Save target as...)

Sender's email address
SCL value
Sender ID value
Replied to time
EXTENDED-PROPERTIES Includes replied to time, sender address, and Message ID fields

Place the CFG's into the same Office folder with the *.ICO files, usually found at C:\Program Files\Microsoft Office\OfficeXX\forms\[4 digit language ID] - replace OfficeXX with your version of Office. For a US English install of Office 2007, the path is C:\Program Files\Microsoft Office\Office12\FORMS\1033

Vista users: Depending on your configuration, you may need Administrator permissions to save the CFG in the Program Files path. I do this by opening IE with "Run as Administrator" permission.

Back to Top  

Install CFG

Remember:
Sender ID only works with Exchange 2003 SP2
SCL requires Exchange 2003's IMF

To install a cfg file:

  1. Go to Tools, Options, Other, Advanced Options, Custom Forms, Manage Forms.
  2. Click the Install button. Choose the.CFG file and install it into your Personal Forms Library
  3. Click OK and return to the main Outlook screen
  4. Right-click on the Column row in your Inbox (or other any other folder) and choose "Field Chooser"
  5. Scroll down and choose "Forms"
  6. Select Personal Forms, choose the Extension Form you added, then click Add
  7. Add the field to your column headings to see the values.

Repeat for each cfg file you wish to add. If Step 6 fails, see Troubleshooting below.

Steps 4 - 7 need to be repeated for each folder where you want to use the field.

Screenshot of the Choose fields dialog showing the SCL Extension Form selected and the field associated with this Extension form CFG.

Back to Top  

Sender ID Labels

For the Sender ID field only.

If you prefer labels instead of numbers, Outlook allows you to create custom fields based on the formula. To do that, follow the following steps.

  1. Right-click on the Column headings in your folder where you enabled SenderID field and choose "Field Chooser"
  2. In the Field Chooser, click New. Type SID as the field name, use Formula as the Type.
  3. Copy and paste the following formula in the formula field:




Click OK and add the newly created SID field into your column headings. Remove the numerical SenderID field from the view, if desired.

Back to Top  

Replied to Labels

To replace the Last Verb Exec Type value with a friendly name:

  1. Right-click on the Column headings in your folder where you added the "Last Verb Exec Type" field and choose "Field Chooser"
  2. In the Field Chooser, click New. Type Action (or any name you choose) as the field name, choose Formula as the Type.
  3. Copy and paste the following formula in the Formula field:


Click OK and add the newly created Action field into your column headings. Remove the numerical "Last Verb Exec Type" field from the view, if desired.

Note: you can sort by the Last Verb Exec fields but you can't sort by the formula fields, so if you want to by the reply action, leave the numerical "Last Verb Exec Type" field in the view.

Troubleshooting

Personal forms dialogIf you have problems adding the SCL form to the Field Chooser and have an entry called Message on the right side of the dialog, select and remove it. SCL should work now.

 

Back to Top

More Information

Original information on each configuration file:
  • SCL value from the "You had me at EHLO" blog
  • Sender ID value from the "You had me at EHLO" blog
  • Viewing the 'Replied to' Time (Exchange Messaging Outlook)
  • Updated Friday July 30 2010
    Copyright Slipstick Systems. All rights reserved.
    Send comments using our Feedback page

    

    Home | What's New | Exchange Server | Outlook | Utilities
    About Slipstick | Feedback | Privacy Policy | Archived Pages | Link to Us | Advertise

    Submit New or Updated Outlook and Exchange Server Utilities

    Hosted by Intermedia.net