How to send appointment using CDO and Excel

[Inovate]

I am trying to send an e-mail from Microsoft Excel VBA using CDO but I am unable to find any information on how to send a meeting request to another person that will appear on their calendar. It is important that I use the CDO code so I do not encounter the securtity warnings. Any suggestions would be great.

 

[genomon]

Why does this have to be sent from Excel? That being asked, first, you will need to download and register cdo 1.2.1 to C:\Program Files\Common Files\System\Mapi\1033\cdo.dll;
this is the earlier release without popup security dialogs (newer is cdo 1.2.1s).

a meeting request to another person that will appear on their calendar

An Outlook calendar? Don't know if I can be of a lot of help as I don't use/program Excel. We accomplish a similar task using Access, CDO and a 3rd party email and pdf library from ACG. If you decide to try the library, it's full of VBA code examples to help with your task.

Alcohol and calculus don't mix, so don't drink and derive.

 

[Inovate]

Let me further explain what I am trying to accomplish. In Excel we have all our reviews for our associates (over 2,000) I have VBA code that will go in to attachmate schedule the remote associate to come in to the facility on a certain date for his/her review and then what I want is the appointment to be put on the managers outlook calendar automatically. This could be done by sending a meeting request to the Manager or since the manager is the one with the application on their computer have it automatically added in the outlook calendar with out an e-mail being sent. I currently have the code to send an e-mail to the manager and it works however I can not seem to identify a way of getting the info on their Calendar.

 

[genomon]

That is a poser. I can't think of any way to do it from your end. At the recipient's end, you could have a form/timer setup to scan his Outlook for a certain attachment and manipulate it in Outlook. Sorry can't think of anything at all to force an action from an unopened email. Maybe there are are some virus-savvy folks out there that can help?...

Alcohol and calculus don't mix, so don't drink and derive.