How to Block Calender for Different Date & Timeusing VBA

[webmax]

Hi

I want to automatically block the Calender in outlook using VBA Macro for Different Date & Time .

I am attaching the Sample Data for your reference. If i fille the data in the excel the calender will automatically book.


With regards
Shahul

 

[Luke M]

Hi Shahul,

Full instructions given here:
http://blogs.technet.com/b/usefultechnology/archive/2005/05/11/404803.aspx

Contains list of what the field names need to be, and pay attention to the fact that it needs a named range. Note that this ends up being a "pull" in Outlook from Excel, rather than a "Push" in Excel to Outlook.