?
Solved

Forms, Fields, Messagebody and Public Folders

Posted on 2004-04-14
2
Medium Priority
?
220 Views
Last Modified: 2010-04-08
Hi, I am quite new to Forms in Outlook but we here have the following wish and I am the one who has to look into it.
A form in a public folder must be sent to one e-mail address. The receiver is a simple mailclient and must receive the information of the serveral fields all together in the messagebody.

The form is intended to be used as a software ordering form. The fields will be: "Name Softwarepackage", "Amount", "Employee number".
The e-mail is used in a Servicedesk application (Magic from NAI). The application will use the messagebody as the servicedesk call information. Therefor the messagebody should look like this:
Name software package: MS Office
Amount: 2
Employee Number: 690124123-456

How can I get these fields into the messagebody?
0
Comment
Question by:fbict
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 7

Accepted Solution

by:
rosesolutions1 earned 2000 total points
ID: 10829740
This code will take the values from your custom fields and put them into the messagebody after the user presses the SEND button (but before it actually gets sent).

In the Form designer, open the vbscript window (Forms/ViewCode). Paste in the following code.  You need to update "MyField1" to whatever you called the first field, etc.

Function Item_Send()
set objProperty = Item.UserProperties.Find("MyField1")
If TypeName(objProperty) <> "Nothing" Then
      Item.Body = Item.Body & "Name software package: " & objProperty.Value
End If
'do it again for each of the others...
End Function



0
 

Author Comment

by:fbict
ID: 10831072
It works....thank you
I only changed the sequence in the Item.Body so that the signature comes at the end.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you have clients or friends from around the world, it becomes a challenge to arrange a meeting or effectively manage your time. This is where Outlook's capability to show 2 time zones in one calendar comes in handy.
The core idea of this article is to make you acquainted with the best way in which you can export Exchange mailbox to PST format.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question