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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. 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

Suggested Solutions

Are you unable to connect or configure Hotmail email account in Microsoft Outlook 2010, 2007? Or Outlook.com emails are not downloading to Outlook? Lets’ see the problem and resolve Outlook Connector error syncing folder hierarchy (0x8004102A).
This article explains how to install and use the NTBackup utility that comes with Windows Server.
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…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

730 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