Topic Options
Rate This Topic
#20621 - 12/28/99 02:18 PM Outlook form to submit requests
kcyronek Offline
Stealth Member

Registered: 06/12/01
Posts: 43
export mail template) given by Remedy. We would like our users to be able
to submit tickets via Outlook but the form does not work unless everything
is typed into the message area (which won't work for us). Remedy says that
someone on ARS List may have a way figured out to do this in outlook using
forms. If you do, please email me!

Kristina MS Cyronek
Remedy Systems Database Administrator
Sunterra Support Center
kcyronek@sunterra.com


To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist


Top
#20622 - 12/28/99 03:33 PM Re: Outlook form to submit requests [Re: scenti]
bach Offline
Stealth Member

Registered: 06/12/01
Posts: 443

Basically, this is what you do:

1. Create a mail message in form design mode. (usually, this is from a new
message, then choose Tools->Forms->Create Form, or something similar to
that)
2. Add fields to your form with the correct data types and names for the
fields you want to submit. You can use the Field Picker to do this.
3. Associate your form elements with the fields (by clicking properties of
the element, and choosing your field).
4. Have a VBA macro run On_Submit which creates the body of the email
message. From the form designer, you can reach this through the "View
Code" button or menu command.
5. The macro should look something like this:

Function Item_Submit()

Body = "# mail template header stuff here" & vbCrLf _
& "Short Description !8!" &
UserVariables.Find("fieldNameofShortDesc").value & vbCrLf _
...
& "#mail template footer stuff"

End Function

Basically, all this does is build the message template from the field
values and submit it to the recipient you specify on the "To:" line of
your template.

I've got an example floating around here somewhere if you want it, let me
know.

Hope this helps,

-Chris Woyton


>
> I have created an outlook form based on the email template (in ARAdmin,
> export mail template) given by Remedy. We would like our users to be able
> to submit tickets via Outlook but the form does not work unless everything
> is typed into the message area (which won't work for us). Remedy says that
> someone on ARS List may have a way figured out to do this in outlook using
> forms. If you do, please email me!
>
> Kristina MS Cyronek
> Remedy Systems Database Administrator
> Sunterra Support Center
> kcyronek@sunterra.com
>
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist
>


To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist


Top
#20623 - 12/28/99 06:31 PM Re: Outlook form to submit requests [Re: scenti]
pass2win Offline
Just Signed Up

Registered: 06/12/01
Posts: 2

I would be very interested in obtaining a sample of this.

Thank you in advance.


Joe


To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist


Top
#20624 - 12/30/99 01:04 PM Re: Outlook form to submit requests [Re: scenti]
sandersd Offline
Stealth Member

Registered: 06/12/01
Posts: 295

Take a look at
http://www.windthrope.com/using_mail_templates_with_outloo.htm

for a sample of an Outlook form for submitting tickets to Remedy which uses
separate compose and read pages to give a user-friendly form.

HTH
David Sanders
Independent Remedy Consultant
__________________________
Westover Consulting Ltd
tel: +44 (0)410 377761
email: sandersd@globalnet.co.uk




----- Original Message -----
From: Cyronek, Kristina
To:
Sent: Tuesday, December 28, 1999 8:18 PM
Subject: Outlook form to submit requests


> I have created an outlook form based on the email template (in ARAdmin,
> export mail template) given by Remedy. We would like our users to be able
> to submit tickets via Outlook but the form does not work unless everything
> is typed into the message area (which won't work for us). Remedy says
that
> someone on ARS List may have a way figured out to do this in outlook using
> forms. If you do, please email me!
>
> Kristina MS Cyronek
> Remedy Systems Database Administrator
> Sunterra Support Center
> kcyronek@sunterra.com
>
>
> To Unsubscribe send e-mail to:
> body of text is: unsubscribe arslist
>


To Unsubscribe send e-mail to:
body of text is: unsubscribe arslist


Top


Moderator:  Matt Reinfeldt