Automatically set up Outlook task when a date is entered in a cell in Excel

lracrft

New Member
Joined
Oct 30, 2017
Messages
9
I'm starting to learn VBA but am not able to write this myself yet (aka I'm just starting to learn but have a working knowledge of SQL so I can interpret some but can't write it myself yet). I want to create automatic follow up reminders for myself for when I need to call someone back. I have the date of my last call with a person in column A, the contact name in B, and a follow up date in column F. When I put a date in F I would like for it to automatically set up an Outlook task for me with that date as the due date and the contact's name as the Subject plus "Follow up" so "John Smith Follow up". I don't need any reminders, just that follow up date as the due date.

Can someone show me what the code for this would look like?
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,214,807
Messages
6,121,679
Members
449,047
Latest member
notmrdurden

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top