Is it possible to create a script that converts Excel to Outlook?

[CoolTech]

Is it possible to create a script that does a lookup in an excel document for all rows where column value = X, then to take the rows returned and add appointments to the outlook calendar including several recipients?

For example:

Excel data:

TIME COUNTRY INDICATOR PREVIOUS RATING

Monday 1st April

9.00 RR Johnson Wax 37.6 D

Outlook:

Set a calendar appointment whenever "rating" column is "D" and add receipients bob and anne.



Is something like this feasible at all?

 

[DaveSimmons]

Probably, both support some automation using their own VBScript or an external VB6 program.

I've never had a reason to do that kind of coding but some of the VB coders here may have. You can also check www.CodeProject.com and MSDN.Microsoft.com for articles on automation if you know VBScript yourself.