Get acquainted with amazing service here

Have any questions? Just call us 061 361 3802

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
End With
End Sub

excel to outlook tasks