Results 1 to 4 of 4

Thread: How to edit formula field in Outlook ?

  1. #1
    Join Date
    Feb 2009
    Posts
    68

    How to edit formula field in Outlook ?

    hey friends.....

    I think I have made certain changes unintentionally in the formula field of the Outlook Express. I wanna ask whether it is possible to edit this formula field in the Outlook Express?
    Can somebody have any information or ideas about the same ? please help

  2. #2
    Join Date
    Jan 2008
    Posts
    3,755

    Re: How to edit formula field in Outlook ?

    To add - If two numeric fields are named Field1 and Field2, then the formula to add them together would look like this:

    [Field1] + [Field2]

    To multiply - If you want to multiply one field by another number, then the formula to multiply them together would look like this:
    (say the number is 7.5)

    [Field9] * 7.5

    All the operators, fields, and functions you can use in formulas are available in the Edit Formula dialog.

  3. #3
    Join Date
    May 2008
    Posts
    3,316

    Re: How to edit formula field in Outlook ?

    You might think that you could edit the formula by selecting View, Current View, Customize Current View, Fields, and using the Show Fields dialog box, which contains a Properties button. However, that button is disabled for custom formula fields.
    Outlook doesn't support exporting custom fields directly. Quick and dirty method:

    1. Put all the items from your form in one folder.
    2. Use a table view to display all the data fields that you want to export to Excel.
    3. Choose Edit | Select All.
    4. Choose Edit | Copy.
    5. Paste to Excel.

  4. #4
    Join Date
    Apr 2008
    Posts
    4,642

    Re: How to edit formula field in Outlook ?

    To perform your edit, first make sure that the field you want to edit appears in a table view.
    If it doesn't, right-click the column headings >> then select Field Chooser.
    Drag the field from the Field Chooser to the view >> Right-click the column headings again >> choose Format Columns.
    In the Format Columns dialog box >> go to the Available fields list >> and select the field whose formula you want to change.

    You can edit directly in the Formula box or click the "..." button to open the formula editor, in which you can select fields and functions.

Similar Threads

  1. Can we Edit Formula in Calculated Field in Pivot Table ?
    By Hadcourt in forum Windows Software
    Replies: 4
    Last Post: 17-05-2011, 06:04 PM
  2. MSP custom field formula to track project progress
    By M0m1 in forum Microsoft Project
    Replies: 1
    Last Post: 30-04-2011, 03:40 AM
  3. Replies: 4
    Last Post: 20-04-2011, 10:51 AM
  4. How to Create, edit or delete an array formula or Pivot Chart
    By agarwalm11 in forum Guides & Tutorials
    Replies: 1
    Last Post: 31-12-2009, 12:22 PM
  5. Field Formula?
    By devbro in forum Microsoft Project
    Replies: 4
    Last Post: 19-12-2006, 05:22 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,663,353.49031 seconds with 17 queries