{{tag>category:"OpenInsight 32-Bit" author:"Chris Meyer" author:"Bob Carten" author:"support@sprezzatura.com" author:"Karen Oland" author:"dbakke@srpcs.com's Don Bakke" author:"[url=http://www.sprezzatura.com]The Sprezzatura Group[/url]" author:"Jim Vaughan" author:"dsig _at_ sigafoos.org"}}
[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]
==== send outlook 2003 calendar message from OI (OpenInsight 32-Bit) ====
=== At 04 AUG 2008 10:35:15PM Chris Meyer wrote: ===
Hi All,
Has anyone sent a MAPI calendar messages from OI. A client wishes to send scheduled events to a mobile phone outlook calendar. Currently he sends a calendar meeting event via microsoft outlook.
I do not know the structure of the Mapi mail message or where to enter the date, start and finish times. I assume the subject and body locations remain the same as a normal email and the
Message=IPM.Microsoft Mail.Note" changed to
Message=IPM.Schedule.Meeting.Request" or
Message=IPM.Appointment" but not sure
and then
Message=0 changed to
Message=1
but what do I set to indicate the calendar parameters.
I would also like to read calendar emails but do not know the email structure to extract details.
TIA
Chris
----
=== At 04 AUG 2008 11:35PM Bob Carten wrote: ===
I think you would be best served to create the attachment as a flat file then use the SendMail command to send that email with attachment.
You can find postings describing the .ics file format. For example see:
[url=http://www.codeproject.com/KB/aspnet/CalendarAppointment.aspx]http://www.codeproject.com/KB/aspnet/CalendarAppointment.aspx[/url]
Sendmail is described in the OpenInsight documentation
----
=== At 05 AUG 2008 03:14AM Chris Meyer wrote: ===
I implemented your suggestion with one problem. The user needs to open and save the attachment (.ics file) before the entry appears in the outlook calendar. Is there a way for the calendar event to appear in the calendar section of outlook so the recipient gets a reminder without first having to save the ics file.
TIA
Chris
----
=== At 05 AUG 2008 10:22AM support@sprezzatura.com wrote: ===
Just shellExecute the file.
support@sprezzatura.com
The Sprezzatura Group Web Site
[i]World Leaders in all things RevSoft[/i]
[img]http://www.sprezzatura.com/zz.gif[/img]
----
=== At 05 AUG 2008 11:44AM Bob Carten wrote: ===
[i]Just shellExecute the file.[/i]
Sweet.
I was going to suggest googling CDONTS appointment, OLE, blah blah blah. Simpler is always better.
----
=== At 05 AUG 2008 12:21PM Karen Oland wrote: ===
Since presumably the email is going to a remote machine, what all would need to be in the email to trigger it (and won't microsoft's ever increasing annoying nanny programs either (a) block the program from running or at the least require going thru one or more nag screens to get the item installed)?
When sent as an attachment, should the end user not have to do more than simply open it to install it into his calendar (presuming he hasn't disabled this in what is probably Outlook at the other end)?
And although this wasn't Chris' original question - could something like Google Calendar be used instead (since it can be set to auto-synchronize with outlook, at least it appears to be able to do so, for those stuck on local calendars).
----
=== At 05 AUG 2008 12:58PM dbakke@srpcs.com's Don Bakke wrote: ===
I guess I'm confused by this. How will the cell phone run ShellExecute?
dbakke@srpcs.com
[url=http://www.srpcs.com]SRP Computer Solutions, Inc.[/url]
[img]http://www.srpcs.com/srpicon1.gif[/img]
----
=== At 05 AUG 2008 01:18PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote: ===
That'll teach me to post whilst on holiday :)
[url=http://www.sprezzatura.com]The Sprezzatura Group[/url]
[i]World leaders in all things RevSoft[/i]
[img]http://www.sprezzatura.com/zz.gif[/img]
----
=== At 05 AUG 2008 02:00PM Jim Vaughan wrote: ===
]] ShellExecute <<
Windows Mobile?
----
=== At 05 AUG 2008 04:19PM Bob Carten wrote: ===
Using Google rather than exchange as the transport is a neat idea.
May as well take a ride on all the work that they have done.
You could exploit the google groups feature can to define virtual workgroups.
[url=http://www.salesforce.com/appexchange/detail_overview.jsp?id=a033000000369gA]Example of pushing data to google calendar[/url]
aDescription of how google groups users can used a publish and subscribe model to share a calendar
----
=== At 06 AUG 2008 01:33PM dsig _at_ sigafoos.org wrote: ===
..
But i am thinking that IF the workstation creates a "icf" and executes it then this should put it in the users calendar. Then if the Mobile device is set to update it's calendar from 'home' it should get updated.
My mobile calendar is constantly updated from Seattle regardless where I am. SO if my Seattle calendar is updated .. so goes the mobile
This *should* work .. yes?
----
=== At 06 AUG 2008 02:02PM dbakke@srpcs.com's Don Bakke wrote: ===
[i]This *should* work .. yes?[/i]
Yes, but I think it misses the point of what Chris is trying to do. We don't know if the user receiving the email is using OpenInsight on a workstation (after all, the email is going *out* to another party) or if they sync their phone to the workstation. In other words, this needs to be a stand-alone solution that works as if Outlook was used to create an appointment and send the invitation to others.
At least that's who I read his request.
dbakke@srpcs.com
[url=http://www.srpcs.com]SRP Computer Solutions, Inc.[/url]
[img]http://www.srpcs.com/srpicon1.gif[/img]
----
=== At 06 AUG 2008 02:38PM Bob Carten wrote: ===
That is why I was thinking CDONTS ( assuming Exchange).
From what I can see, if you want the client to pull it, the user will need to accept the attachement. If the client is Outlook, a low tech you could automate the accepting is with a rule, but I'm not sure about suppressing the message.
CDONTS communicates directly with the Exchange server, rather then through the outlook client. I used it for bulk email a few years back. Am not sure it would solve the problem, but suspect it is the way to go.
see [url=http://gsexdev.blogspot.com/2007/02/creating-summary-email-of-all.html]http://gsexdev.blogspot.com/2007/02/creating-summary-email-of-all.html[/url] for an example of the work required.
----
=== At 06 AUG 2008 05:58PM dsig _at_ sigafoos.org wrote: ===
but if they aren't using OI then maybe OI isn't the best solution
[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=0832AED4739FBEF58525749C000E36DE|View this thread on the Works forum...]]