From

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

From	Logged in as: Guest

arrSession:exec spGetSession 2,2,53540

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> From
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

From - 11/14/2007 2:41:29 AM

adampope

Posts: 5
Score: 0
Joined: 11/13/2007
Status: offline

I've created an 'events' database that contains date from and to, times, titles, description,and has the 'user' figured out.

On the data access page that displays this information, I'm hoping to have an image link that when clicked on will bring up an Outlook Calendar file with all the fields prefilled in. Any idea how I'd go about wrting the vbscript for that? So far I've got:

</STYLE>
<script language=vbscript for=Open_Calendar event=onclick>

</script>

I'm thinking the iCalendar format (ics) is probably better since it's open and will work for Mac users too. The following are the contents of an iCalendar file:

BEGIN:VCALENDAR
PRODID:-//Microsoft Corporation//Outlook 11.0 MIMEDIR//EN
VERSION:2.0
METHOD:REQUEST
BEGIN:VEVENT
ATTENDEE;CN="Adam Pope";ROLE=REQ-PARTICIPANT;RSVP=TRUE:MAILTO:adam.pope@arup.com
ORGANIZER:MAILTO:adam.pope@arup.com
DTSTART:20071204T100000Z
DTEND:20071204T103000Z
LOCATION:London\, United Kingdom
TRANSP:OPAQUE
SEQUENCE:0
UID:040000008200E00074C5B7101A82E00800000000D0C088BFD126C8010000000000000000100
0000018C5F67742D8564091AF83B562EDE21A
DTSTAMP:20071114T151928Z
SUMMARY:This is a test
PRIORITY:5
X-MICROSOFT-CDO-IMPORTANCE:1
CLASS:PUBLIC
BEGIN:VALARM
TRIGGER:-PT15M
ACTION:DISPLAY
DESCRIPTION:Reminder
END:VALARM
END:VEVENT
END:VCALENDAR

My question is what do I need to write to begin this operation, what are the commands for Date=DTSTART, how do I convert the date to the ICS format, and how do wind up opening the resulting file as an ics?

Should I be paying someone for this information?

As ever, any help you can provide is greatly appreciated!

Adam Pope