Set Tasks Excel Outlook

Using the below VBA code you can set tasks excel outlook by simple entering the date and allocating the information.

Many people keep a list of things to do — on paper, in a spreadsheet, or with a combination of paper and electronic methods. In Microsoft Outlook you can combine various lists into one, get reminders and track task progress.

Sub NewTask()
With CreateObject(“Outlook.Application”).CreateItem(3)
.Subject = Cells(2, “A”) ‘ Cell A2 is the subject line
.StartDate = Now
.DueDate = Cells(2, “E”) ‘ Cell E2 is the Due Date or Date of Task
.ReminderSet = True
.ReminderTime = .DueDate – 3 + TimeValue(“8:30AM”) ‘ Reminder Date and Time
.Body = Cells(2, “B”) & vbNewLine & vbNewLine & Cells(2, “C”) ‘ Cell B2 is the Body Description of the Outlook Task
.Save
End With
End Sub