Solved

How can I autmate the export of a shared resource's calendar in Outlook to an Intranet page?

Posted on 2009-07-10
4
281 Views
Last Modified: 2012-05-07
Using MS Outlook  2003 & Exchange 2003.  Have a shared calendar (resource item, nobody checks account).  Need to export events from its calendar to an Intranet.  Needs to be automated to export a calendar from a 07/01/2009 - 12/31/2009.
0
Comment
Question by:dimmergeek
[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
  • 2
  • 2
4 Comments
 
LVL 3

Expert Comment

by:Fingo
ID: 24825887
I use the following code to export our resource object's calendar items to a html file, which is then viewable by everyone.

http://www.outlookcode.com/codedetail.aspx?id=564

This is not the original page I pulled my scripts from but it is the same author. It looks like he did not post his .css templates on this site.  Let me know if you think this might work for you, and i can pack up the files I originally downloaded and send them to you.

It was developed for exchange 5.5 but still works on exchange 2003.  
0
 
LVL 7

Author Comment

by:dimmergeek
ID: 24826216
Fingo,
You'll have to forgive me.  I know HTML, CSS and JavaScript.  I am trying to learn VB (I think that's what this is...), but for all intenstive purposes, I know nothing.
How do I take the script in the link and convert it to a file I can use?

Where/How do I enter the path of the HTML file to be exported?
Where/How do I enter the name of the resource I am proxying?

Forgive my newbie questions...
0
 
LVL 3

Accepted Solution

by:
Fingo earned 250 total points
ID: 24826470
This might be easier if you see the finalized files and just edit what you need.

Place WebCalendarHTML.VBS and Settings.txt on your exchange server. Edit settings.txt accordingly to your environment.  The user needs full mailbox rights to the resources you will be exporting.

FSUsername is user/pass of user who has rights to run the .vbs on the exchange server.  The user/pass in the MAILBOX line are users who has full access to those individual mailboxes.

Please the remaining files into the shared directories you specified in the settings.txt file.

When you run the .vbs file it will create a <resource name>.html file in the shared folder.  You will then also need to modify the index.html to display your resources.  About six lines to edit and you should be all up and running.

File
http://www.4shared.com/file/117247687/bd3cd628/HTMLCalendar.html
0
 
LVL 7

Author Closing Comment

by:dimmergeek
ID: 31602140
Thanks!  You're a lifesaver!  I gotta learn VB...
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

In-place Upgrading Dirsync to Azure AD Connect
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
In this video we show how to create a mailbox database in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Servers >> Data…
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…
Suggested Courses

617 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