Hello,

This is my first post here.  I'm putting in Salesforce to my organisation and it has been good so far.  However, there is one feature which is missing, and I really need to find a workaround.

During our Opportunitiy stage, we have various meetings.  Some of the people who attend are Salesforce users, most of the people aren't, but their emails are in the system and accessible to the either as contacts or custom email fields.  It is obviously easy to create a workflow rule that emails all the people I want to email when a meeting is arranged, however I want to accompany the email with an ICS attachment that has the meeting time.

I'm not a programmer, although I do play with HTML code in my spare time for fun.  As such, I may well ask things that appear a bit dumb - apologies in advance for this.

However, I have found the two following bits of code which might make my objective possible, with a bit of tweaking.  If you can give me any help or advice, I shall be most grateful.  I have also realised that I'm noto the only one who wants this goal, so if you can come up with the answer, there will be grateful people around the world.

Thanks in advance!

Alex.

CODE 1:

<?php
  $date      = $_GET['date'];  $startTime = $_GET['startTime'];  $endTime   = $_GET['endTime'];  $subject   = $_GET['subject'];  $desc      = $_GET['desc'];  $ical ="BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//hacksw/handcal//NONSGML v1.0//EN
BEGIN:VEVENT
UID:". md5(uniqid(mt_rand(),true))."example.com
DTSTAMP:". gmdate('Ymd').'T'. gmdate('His')."Z
DTSTART:".$date."T".$startTime."00Z
DTEND:".$date."T".$endTime."00Z
SUMMARY:".$subject."
DESCRIPTION:".$desc."
END:VEVENT
END:VCALENDAR";//set correct content-type-header  header('Content-type: text/calendar; charset=utf-8');  header('Content-Disposition: inline; filename=calendar.ics');  echo $ical;exit;?>

CODE NO 2

publicvoid Sendmail_With_IcsAttachment()

        {

            MailMessage msg = newMailMessage();

            //Now we have to set the value to Mail message properties

            //Note Please change it to correct mail-id to use this in your application

            msg.From = newMailAddress("xxxxx@xyz.com", "ABC");

            msg.To.Add(newMailAddress("yyyyy@xyz.com", "BCD"));

            msg.CC.Add(newMailAddress("zzzzz@xyz.com", "DEF"));// it is optional, only if required

            msg.Subject = "Send mail with ICS file as an Attachment";

            msg.Body = "Please Attend the meeting with this schedule";

            // Now Contruct the ICS file using string builder

            StringBuilder str = newStringBuilder();

            str.AppendLine("BEGIN:VCALENDAR");

            str.AppendLine("PRODID:-//Schedule a Meeting");

            str.AppendLine("VERSION:2.0");

            str.AppendLine("METHOD:REQUEST");

            str.AppendLine("BEGIN:VEVENT");

            str.AppendLine(string.Format("DTSTART:{0:yyyyMMddTHHmmssZ}", DateTime.Now.AddMinutes(+330)));

            str.AppendLine(string.Format("DTSTAMP:{0:yyyyMMddTHHmmssZ}", DateTime.UtcNow));

            str.AppendLine(string.Format("DTEND:{0:yyyyMMddTHHmmssZ}", DateTime.Now.AddMinutes(+660)));

            str.AppendLine("LOCATION: " + this.Location);

            str.AppendLine(string.Format("UID:{0}", Guid.NewGuid()));

            str.AppendLine(string.Format("DESCRIPTION:{0}", msg.Body));

            str.AppendLine(string.Format("X-ALT-DESC;FMTTYPE=text/html:{0}", msg.Body));

            str.AppendLine(string.Format("SUMMARY:{0}", msg.Subject));

            str.AppendLine(string.Format("ORGANIZER:MAILTO:{0}", msg.From.Address));

            str.AppendLine(string.Format("ATTENDEE;CN=\"{0}\";RSVP=TRUE:mailto:{1}", msg.To[0].DisplayName, msg.To[0].Address));

            str.AppendLine("BEGIN:VALARM");

            str.AppendLine("TRIGGER:-PT15M");

            str.AppendLine("ACTION:DISPLAY");

            str.AppendLine("DESCRIPTION:Reminder");

            str.AppendLine("END:VALARM");

            str.AppendLine("END:VEVENT");

            str.AppendLine("END:VCALENDAR");

            //Now sending a mail with attachment ICS file.                     

            System.Net.Mail.SmtpClient smtpclient = new System.Net.Mail.SmtpClient();

            smtpclient.Host = "localhost"; //-------this has to given the Mailserver IP

            smtpclient.Credentials = System.Net.CredentialCache.DefaultNetworkCredentials;

            System.Net.Mime.ContentType contype = new System.Net.Mime.ContentType("text/calendar");

            contype.Parameters.Add("method", "REQUEST"); 

            contype.Parameters.Add("name", "Meeting.ics");

            AlternateView avCal = AlternateView.CreateAlternateViewFromString(str.ToString(), contype);

            msg.AlternateViews.Add(avCal);

            smtpclient.Send(msg); 

        }