Automate Outlook to create new meeting request

kishengiggs1

New Member
Joined
Jun 21, 2011
Messages
23
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

MrExcel MVP
Joined
Oct 15, 2007
Messages
6,075
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-questions/812358-sending-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.
 

Forum statistics

Threads
1,086,122
Messages
5,387,975
Members
402,092
Latest member
S_S

Some videos you may like

This Week's Hot Topics

Top