Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2002
    Posts
    64

    Unhappy Automating MSOutlook, need help

    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?

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    What do you want to automate within Outlook?
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

  3. #3
    Join Date
    Feb 2002
    Posts
    64
    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!

  4. #4
    Join Date
    Feb 2002
    Posts
    64

    Cool

    Figured out a solution......

  5. #5
    Join Date
    May 2002
    Posts
    4
    How did you do it?

    Thanks,
    bart@acordia.com

  6. #6
    Join Date
    Feb 2002
    Posts
    64

    Cool

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •