• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1131
  • Last Modified:

cfmail and outlook appointment

Hi,

Just checking to see if anyone knows if and how one can send a cfmail to an outlook recipient as an appointment.

Thanks,
Bonnie
0
Bonnie_K
Asked:
Bonnie_K
  • 3
  • 2
1 Solution
 
usachrisk1983Commented:
Send an ICS file to them, that Outlook will allow them to add to their calendar.  Just use CFFILE to build the ICS file, and then use CFMAIL/CFMAILPARAM to mail it to them.  If you need assistance with the ICS format, please let me know.
0
 
Bonnie_KAuthor Commented:
Yes, I need help with the ICS file format.  What does it need to contain?  

Thanks usachisk1983, I thought this was not going to be possible!
0
 
Bonnie_KAuthor Commented:
I think I figured out the format...now I'm going to test.  I created a mail message and saved it to the .ics format and opened it up and looked around.  I'll let you know how it goes...
0
 
usachrisk1983Commented:
That's awesome, and glad you figured out ICS files.  Let me know!
0
 
Bonnie_KAuthor Commented:
Here's the snippet I ended up using.  Just thought I'd paste it in for others searching for a similar solution.  I think that this will work great.  It seems the only difference is that a user has to open the attachment.  When receiving a calendar mail from another outlook user, it has a different format so the user can click accept / reject.  I don't see this as a problem, we'll see what the person who asked for this thinks..

Thanks again usachrisk1983, you made it possiblt for me to have a productive Monday (unusual :) !

-Bonnie

<cffile action = "write"
file = "c:\inetpub\wwwroot\projects\ics\assignmentfrom#varuser#.ics"
output = "
BEGIN:VCALENDAR
PRODID:-//Microsoft Corporation//Outlook 11.0 MIMEDIR//EN
VERSION:2.0
METHOD:PUBLISH
BEGIN:VEVENT
ORGANIZER:MAILTO:#varAssigned_To_Username#@mycompany.us
DTSTART;VALUE=DATE:#DateFormat(varDueDate,'yyyymmdd')#
DTEND;VALUE=DATE:#DateFormat(varDueDate+1,'yyyymmdd')#
TRANSP:OPAQUE
SEQUENCE:0
UID:
DTSTAMP:#DateFormat(Now(),'yyyymmdd')#
DESCRIPTION:Project Number: #varProject_Number#\nTask Number: #varTask#\nTask Description: #varName#\n
SUMMARY:#varProject_Number# Task: #varTask# (#varName#)
PRIORITY:5
X-MICROSOFT-CDO-IMPORTANCE:1
CLASS:PUBLIC
BEGIN:VALARM
TRIGGER:-PT15M
ACTION:DISPLAY
DESCRIPTION:Reminder
END:VALARM
END:VEVENT
END:VCALENDAR
">

<cfmail
from="#varUser#@mycompany.us"
to="#varAssigned_To_Username#@mycompany.us"
subject="Task Assigment Calendar Entry (#varProject_Number#-#varTask#)"
mimeattach = "c:\inetpub\wwwroot\projects\ics\assignmentfrom#varuser#.ics"
type="html">
<font face="Arial">Please open the attachment to add this task due date to your outlook calendar.</font>
                        
</cfmail>
1

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now