We have a wish to send an ical (calender item) file to an extern email address. If we can create an ical file we can easily invite people to appointments without switching to outlook.
The ical format is pretty standardized and the most used calenders can work with this.
Create Ical item from data to send by email
Windows GUI
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
That's a great idea, I actually created my own code to write an iCal file and send it through dbmail. But it would have been much easier if there would have been a connector which could handle this.
First of all, here is an example of how to create a string containing an ical file: https://sqlqueen.wordpress.com/2011/04/25/create-ics-file-in-sql-server/
Where I use this, an e-mail is sent right after the ical file is created. Now dbmail is not able to send actual files, but it is able to send query results. So the way I do it is as follows:
I hope this is enough for you to get this working. Now the same would work if you wanted to send an a-mail through a process, but then it would not be necessary to build the string as a query
More on this https://office.thinkwisesoftware.com/docs/docs/kb/exchange.html
Unfortunately, this idea has not received enough votes. Because we want to keep the focus on ideas that are in high demand in our Community, we are closing this idea.
Fortunately, as@Mark van den Berg pointed out an alternative for this is present.
Updated idea status Open → Closed