Solved

Forms, Fields, Messagebody and Public Folders

Posted on 2004-04-14
2
213 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Resolve Outlook connectivity issues after moving mailbox to new Exchange 2016 server
Sometimes Outlook might have problems sending a message. There may be various causes- corrupted PST, AV scanner etc. The message, instead of going to the Sent Items folder, sits in the Outbox indefinitely. To remove it you can use a free tool cal…
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 video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

743 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

13 Experts available now in Live!

Get 1:1 Help Now