Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macro with Outlook (2000)

    Is is possible to create a macro that will add a appointment to your Outlook calendar or someone elses calander? Thanks <img src=/S/help.gif border=0 alt=help width=23 height=15>

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Macro with Outlook (2000)

    Yes it is. You will need to look at the object model for Outlook, and you will want to use OLE Automation to make it happen. It's certainly not a trivial task, but it can be done as easily as sending email via OLE. An appointment in your own calendar is pretty straightforward. One in someone elses calendar is more complex as you will normally have to send it as a meeting request. Check out the MS Knowledge base on OLE Automation and Outlook 2000. You might also want to snag a copy of the Access 2000 Developer's Handbook (Sybex by Litwin, Getz, et. al.) - I believe there are several examples of Automation there.
    Wendell

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Macro with Outlook (2000)

    Only if you are using Macro in the Office VBA sense rather than in the Access sense. In that case, see Wendell's reply. If you're trying to do it from an Access macro, the answer is no, you have to use code.
    Charlotte

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Wetherby, Yorkshire, England
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro with Outlook (2000)

    Try Helen Fedemas site (www.helenfedema.com). She has loads of code samples for free. I've amended a few to automate things in Access. One for passing names to Outlook Contacts can be amended to pass dates to Calendar. Give it a try.
    Peter Herworth

  5. #5
    New Lounger
    Join Date
    Mar 2002
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro with Outlook (2000)

    Thanks, but the site seems to be disabled.. or you sent me the wrong address??

  6. #6
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro with Outlook (2000)

    Here is the link : Helen Feddema with 2 d's
    Francois

  7. #7
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Wetherby, Yorkshire, England
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro with Outlook (2000)

    William
    Sorry about that. Someone else has already posted the right spelling. Good luck
    Peter Herworth

  8. #8
    New Lounger
    Join Date
    Mar 2002
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro with Outlook (2000)

    Thanks again. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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