?
Solved

cfmail and outlook appointment

Posted on 2006-07-03
5
Medium Priority
?
1,128 Views
Last Modified: 2013-12-24
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
Comment
Question by:Bonnie_K
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 13

Accepted Solution

by:
usachrisk1983 earned 2000 total points
ID: 17033303
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
 

Author Comment

by:Bonnie_K
ID: 17033342
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
 

Author Comment

by:Bonnie_K
ID: 17033402
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
 
LVL 13

Expert Comment

by:usachrisk1983
ID: 17033986
That's awesome, and glad you figured out ICS files.  Let me know!
0
 

Author Comment

by:Bonnie_K
ID: 17034015
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

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In our day to day coding, how many times have we come across a necessity to check whether a URL is a broken link or not? For those of you that answered countless and are using ColdFusion like myself, then this article is for you.  It will show yo…
When it comes to showing a 404 error page to your visitors, you do not want that generic page to show, and you especially do not want your hosting provider’s ad error page to show either. In this article, I will show you how to enable the custom 40…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

649 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