PDA

View Full Version : Automating MSOutlook, need help


TJoy
04-03-02, 15:16
Not sure if this is the right forum, but I am trying to automate Outlook 2002 and cannot find much help. I've search MSDN, tried a couple of forums, but can't seem to find any "comprehensive" resources. Can anyone point me in the right direction?

Ruudboy
04-05-02, 09:06
What do you want to automate within Outlook?

TJoy
04-08-02, 12:14
You can publish your calendar as a web page by doing the File, Save As Web Page, etc.

What I'd like to do is get this to run automatically on close of Outlook but can't get the code together. We need to view the General Managers' calendar on our intranet when he is not here and we do not have Exchange. Seems to me that if we could run a little routine whenever he exits Outlook, we would have his calendar up to date on the intranet whenever he's out of the office.

Any tips gratefully accepted!

TJoy
05-10-02, 16:27
Figured out a solution......

bart_chambers
05-14-02, 15:15
How did you do it?

Thanks,
bart@acordia.com

TJoy
05-16-02, 14:28
I'm almost embarrassed to say...

I was trying to make it more difficult. I just went to the good ol' fashioned SendKeys method:

Sub SaveCalendar()

SendKeys "%Fg"
SendKeys "%S"
SendKeys "%Y"

End Sub

Once you do an initial Save As Web Page on the File menu, the settings are saved. You call the above procedure and away it goes...