Parker Software Ltd Homepage
Forum Home Forum Home > Email2DB Email Parser > Scripting
  New Posts New Posts RSS Feed: Connecting to Custom Outlook Appointment Form
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Connecting to Custom Outlook Appointment Form
 Post Reply Post Reply
Author
Message
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
hhicks330 View Drop Down
New User
New User


Joined: 30 Jul 2012
Location: United States
Posts: 1 		Post Options Post Options   Quote hhicks330 Quote  Post ReplyReply Direct Link To This Post Topic: Connecting to Custom Outlook Appointment Form
    Posted: 30 Jul 2012 at 10:05pm
So I'm working on trying to try and connect to a custom Outlook Appointment form through VBScript. I created a working script that uses the normal Appointment form, but I am unsure of how to connect to a custom Outlook form.

I saved my custom form to the Organizational Forms Library, under the name CustomAppointment. And the only extra field added is the "ApptID" field.

Can anybody give me a heads up on how I might do this?

This is my current code:

Sub Main()
Dim objOL      'As Outlook.Application
Dim ObjAppt    'As Outlook.AppointmentItem
Const olAppointmentItem = 1
Const olMeeting = 1

Set objOL = CreateObject("Outlook.Application")
Set ObjAppt = objOL.CreateItem(olAppointmentItem)
With ObjAppt
.Subject = FIELDS_Value("ServiceDesc")
.RequiredAttendees = FIELDS_Value("UserID") + "@cgfs.org"
.Location = FIELD_Value("Location") + " - " + FIELDS_Value("Branch")
.Start = FIELDS_Value(ApptDate) + " " + FIELDS_Value(StartTime)
.End = FIELDS_Value(ApptDate) + " " + FIELDS_Value(EndTime)
.Body = FIELDS_Value("Notes")
.Save
End With

Set ObjAppt = Nothing
Set objOL = Nothing
EndSub
Back to Top
James Horton View Drop Down
Admin Group
Admin Group
Avatar
Technical Support

Joined: 01 Jun 2009
Location: Stoke-on-Trent
Posts: 277 		Post Options Post Options   Quote James Horton Quote  Post ReplyReply Direct Link To This Post Posted: 03 Aug 2012 at 11:34am

To my understanding this is due to the VBScript Office elements not being possible within the context of a service. I believe this is due to the components themselves and not Email2DB, but Email2DB is running as a Windows Service on the machine so this would mean that the objects are not available how you are attempting to use them.

This is a change that Microsoft have made to their components deliberately to mean that services running on a machine may not use them.

Currently there is not a script object within Email2DB to offer the creation of appointments within Exchange/Outlook. You are able to apply logic actions to the events within the Actions area of Email2DB’s trigger and from here you can check the values of either variables or items within the Field Extraction to see if an If condition is met. If you place your Actions within the If conditions behaviour, then you can add further control to the Appointment creation within the trigger. This along with the use of variables within the Action itself should allow you to create dynamic action elements.

I would imagine that script functionality may be made available in a future release of the Email2DB product, but this is not yet possible. 


Edited by James Horton - 03 Aug 2012 at 11:35am
Best Regards,

James Horton
Technical Analyst
Parker Software
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.141 seconds.
These are the forums for Parker Software, developers of Live Chat Software: WhosOn and Email Automation Software: Email2DB.