Excel macro that auto creates Outlook appointments based on data of particular cell range

Hi all,

firstly I am a novice so please let me know if you dont understand or I have the incorrect terminology.

I am attempting to create a VBA macro where by when a date is entered within a certain cell range it automatically creates an appointment in Outlook starting on the date entered as an all day event and where data such as appointment title and subject are drawn from other cells in the same worksheet.

For example. Say I format column C as date cells, id like the macro to run when a date is entered in any cell within the C column and create an appointment with the title taken from B2 & A1 and then other appointment data like subject, location etc can be the same across all appointments.



Perhaps explaining the reason why I want to create such a macro might help too. I am an Urban Planner that works within Government and when I receive a planning application to assess I have 28 calendar days from the lodgement date to request any further information from the applicant. So I wanted to create a macro that would automatically create an appointment in Outlook for that date to remind myself. I do have other macros id like to create that are similar but baby steps haha

If you would like any further info id be happy to provide. I have attached an example below

Thanks test.xlsx

since you have office 365 check out power automate, there are several tutorials on youtube

take a look at this also:

https://www.excelforum.com/excel-pro...xcel-data.html

try below but you need to specify where the start, end, subject etc. are located

Please Login or Register  to view this content.