Macro with Outlook (2000)

Topic

New Reply

Is is possible to create a macro that will add a appointment to your Outlook calendar or someone elses calander? Thanks

Reply | Quote

Replies

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.

Reply | Quote

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.

Reply | Quote

Try Helen Fedemas site (http://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

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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

Reply | Quote

Thanks again.

Reply | Quote