Set Up Macro to send reminders to Outlook Calendar

[slohman]

I have a task that has to be done in Column C3:C600 I have dates Column D3:D600 if 1 month before the date in Column D, I need a reminder in Excel for the duration of all day event.


The subject would be Column A, location would be Column B and the body of appointment would be Column E


I have attached a small example.


Thanks in advanced.

 

[Debraj]

Hi Slohman,

I have attached a small example.

 

[bobhc]

Good day slohman


This link may help you.


http://danielcurran.com/outlook/how-to-create-a-reminder-email-for-outlook-email-from-excel/


If you have not already done so read this green sticky about uploading files


http://chandoo.org/forums/topic/posting-a-sample-workbook

 

[slohman]

I have looked at that link by danielcurran it explains how to create a reminder email but not a appointment.


http://www.2shared.com/file/0OkoOQsP/Works_Project_Schedule_Tester.html

 

[bobhc]

good day slohman


This link has various VBA for sending Appointment reminders.


http://www.slipstick.com/developer/send-email-outlook-reminders-fires/

 

[slohman]

Can someone help with this I only need an appointment in outlook not an email reminder

 

[SirJB7]

Hi, slohman!

Checked this yet?

http://msdn.microsoft.com/en-us/library/office/ff861308.aspx

Regards!

 

[slohman]

Sorry SirJB7

Have you read my original post regarding excel macro for outlook reminders

 

[SirJB7]

Hi, slohman!

Yes, not deeply but I did. And my comment was related to your 2nd post where you wrote "it explains how to create a reminder email but not a appointment", and as my posted link was referring to create appointments I thought it might help you. If it didn't, sorry, go on looking for.

Regards!