Solved

Forms, Fields, Messagebody and Public Folders

Posted on 2004-04-14
2
214 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
2 Comments
 
LVL 7

Accepted Solution

by:
rosesolutions1 earned 500 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
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…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

863 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now