Macro with Outlook (2000)

[williamyoung]

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>

[WendellB]

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.

[charlotte]

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.

[herworth]

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

[williamyoung]

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

[Francois]

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

[herworth]

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

[williamyoung]

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