Larry Rungren
asked on
Code to export calendar appointments with link to SQL Server for field substitution
I have a public calendar in Exchange 2003.
I want to export as .ics files and modify the Subject: and possibly the description and filter by type
and rename the output filename with part of the description field.
These files will reside on a web server and when customers wish to have an entry placed in their outlook calendar there will be a link on the product page fromm our web site to this file.
As the entries are processed there may be substitution of data from tables in a SQL Server database.
Has anyone else done this?
I want to export as .ics files and modify the Subject: and possibly the description and filter by type
and rename the output filename with part of the description field.
These files will reside on a web server and when customers wish to have an entry placed in their outlook calendar there will be a link on the product page fromm our web site to this file.
As the entries are processed there may be substitution of data from tables in a SQL Server database.
Has anyone else done this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
A tip of the hat to Helen.
I searched for a resolution to this for 3 weeks and somehow stumbled into this code which was clear,simple to modify stick into a vb app then modifications were simple to do.
I searched for a resolution to this for 3 weeks and somehow stumbled into this code which was clear,simple to modify stick into a vb app then modifications were simple to do.
Jeff,
Exchange 2003 is outdated by Exchange 2007 and Exchange 2010. There is better programming from what I can tell against users/mailboxes rather then public folders.
.ics files can be modified and downloaded, you would even be able to add email addresses for meeting invites.
this web site has lots of pointers for solutions for MS Exchange
http://www.slipstick.com/
I have seen websites that create an ics file for the visitor to accept / import. I guess you have a web form that will create an ics then verify fields on before posting to a public folder / mailbox?
Hope that helps some.
Mark