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
280 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

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

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

In this step by step procedure, you will come to know the details of creating an Outlook meeting in 2007, 2010, 2013 & 2016.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

728 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