Automate Outlook to create new meeting request

[kishengiggs1]

I would like to know if there is any way to automate outlook to create new meeting request and send it automatically like on a certain day every week for a long period of time. The key is for it to be sent only on that certain day and that is why it is different than the multiple occurrence feature in Microsoft Outlook.

thanks
Kishen

 

[John_w]

You could do this with a Windows Scheduled Task which runs a VBScript (.vbs) file. There is code at http://www.mrexcel.com/forum/excel-...ing-outlook-invite-via-excel.html#post3969261 which creates and sends an Outlook meeting request.

Open Notepad and paste the code and add meetingbooking at the top (to call the Sub procedure). Customise the meeting settings as required (use Date and TimeValue instead of the fixed Start and End times) and change Display to Send. Other changes may be needed to make it work with VBScript. Save the Notepad file as Outlook_meeting.vbs, and create a Windows Scheduled Task which runs Outlook_meeting.vbs at the required schedule.