Sending calendar invite with an attachment

[Pradeep D]

Hi,

I've a requirement where I've to send a calendar invite with a zip file attached to it. All the fields like distribution list, date and time, duration, content of the invite are to be stored in a spreadsheet from where the macro can pick and send the calendar invite with the attachment to the required distro. How can I achieve this?

Thanks and regards,
Pradeep D
+91-984-935-5969

 

[Asheesh]

Welcome to the forum.

I could definitely write a snippet for you however, I do not have outlook configured at personal laptop...nevertheless, you can go through the below links and they shall definitely help..

https://blogs.msdn.microsoft.com/br...cheduling-appointments-in-outlook-from-excel/

http://stackoverflow.com/questions/8200018/excel-create-outlook-meeting-request-not-able-to-send

http://www.slipstick.com/developer/create-appointments-spreadsheet-data/