VBA - Adding to calendar as appointment

[Mikee85]

Hi,

I currently use a number of Macros to organise my projects through Excel (one of which sends automated emails) however, i was looking at this information (the same that is sent via email) be added to my outlook calendar as appointments (as all day events).

I've tried a few variations but with no joy. (Basic VBA knowledge).

Thank you for your assistance in advance.
Mike

 

[Chihiro]

Without details of your project and workbook set up, it's difficult to give you specific help. If you Google, there are plenty of example out there.

One of the better example can be found at msdn below.
https://blogs.msdn.microsoft.com/br...cheduling-appointments-in-outlook-from-excel/

 

[Mikee85]

Good afternoon,

Thank you for replying to my question.

I've had a look at that link previously and i couldn't get it to work for me.
I've attached a sample file of the WB i use.

Effectively, i have the macro find today's date in each sheet and if any return true, sends an email to a team member with the details.

i would like the same however, instead of creating / sending an email, it add's to my outlook Calendar as an appointment for that day as the following.

Title = Column D (Description)
Location = Blank
All day event = True
Category = Yellow
Body = Column A
Space
Column C
Column D
Space
Column H
Column I
Column J
Space
Column L
Save & Close

I'm novice at this and I've tried a few examples but i can't seem to make it work.
your help is greatly appreciated in advance.
Thank you

Mike