Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to edit formula field in Outlook ?

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 14-04-2009
Member
 
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

Reply With Quote
  #2  
Old 14-04-2009
Member
 
Join Date: Jan 2008
Posts: 3,750
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.
Reply With Quote
  #3  
Old 14-04-2009
Member
 
Join Date: May 2008
Posts: 3,312
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.
Reply With Quote
  #4  
Old 14-04-2009
Member
 
Join Date: Apr 2008
Posts: 4,641
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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to edit formula field in Outlook ?"
Thread Thread Starter Forum Replies Last Post
Can we Edit Formula in Calculated Field in Pivot Table ? Hadcourt Windows Software 4 17-05-2011 06:04 PM
MSP custom field formula to track project progress M0m1 Microsoft Project 1 30-04-2011 03:40 AM
How to edit a field in about:config through a program in Firefox Zion Technology & Internet 4 20-04-2011 10:51 AM
How to Create, edit or delete an array formula or Pivot Chart agarwalm11 Guides & Tutorials 1 31-12-2009 11:22 AM
Field Formula? devbro Microsoft Project 4 19-12-2006 04:22 AM


All times are GMT +5.5. The time now is 01:35 AM.