Field formula in custom form

[Mike5116]

Hello and thank you for looking at my post.

I am new to Outlook, all I ever needed before was Express. But I felt it
was time to grow and learn something new ...........what really wanted was
to create an Email form that would hopefully act as a sort of order form also.

I've taken the standard Email form and added 10 fields to it. The first 8
are for ordering and item and only a number needs to be entered. In field 9
I was hoping to total fields 1-8 automatically, I'm not sure how to do this.
In field 10 I wanted to multply field 9 by a dollar amount, I don't know how
to do this either.

I am still trying to read and learn how all this info is tabulated and could
be exported to an excel file. Most of the web sites I find "technically
challanging", but I'm getting there, my old brain ain't what it use to be

If you choose to leave a responce, THANK YOU. If not, still have a great
day.

 

[Sue Mosher [MVP-Outlook]]

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

[Field1] + [Field2]

To multiply one field by another number, use something like this:

[Field9] * 3.15

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

Before you go too deeply into customizing a message form, though, I'd suggest you make sure that your scenario and mail environment meets the prerequisites. See http://www.outlookcode.com/article.aspx?id=61

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.

If some of the fields are multi-line, see Eric Legault's handy tip for an Excel formula to break up the lines -- http://blogs.officezealot.com/legault/archive/2005/04/08/4502.aspx

The alternatives are to write your own custom VBA code or to use a third-party application. See http://www.outlookcode.com/article.aspx?ID=23

 

[Mike5116]

Thank you Sue, you reply was a big help
--
CZ Lives Forever

Mike5116

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

[Field1] + [Field2]

To multiply one field by another number, use something like this:

[Field9] * 3.15

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

Before you go too deeply into customizing a message form, though, I'd suggest you make sure that your scenario and mail environment meets the prerequisites. See http://www.outlookcode.com/article.aspx?id=61

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.

If some of the fields are multi-line, see Eric Legault's handy tip for an Excel formula to break up the lines -- http://blogs.officezealot.com/legault/archive/2005/04/08/4502.aspx

The alternatives are to write your own custom VBA code or to use a third-party application. See http://www.outlookcode.com/article.aspx?ID=23
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54

I am new to Outlook, all I ever needed before was Express. But I felt it
was time to grow and learn something new ...........what really wanted was
to create an Email form that would hopefully act as a sort of order form also.

I've taken the standard Email form and added 10 fields to it. The first 8
are for ordering and item and only a number needs to be entered. In field 9
I was hoping to total fields 1-8 automatically, I'm not sure how to do this.
In field 10 I wanted to multply field 9 by a dollar amount, I don't know how
to do this either.

I am still trying to read and learn how all this info is tabulated and could
be exported to an excel file. Most of the web sites I find "technically
challanging", but I'm getting there, my old brain ain't what it use to be