2 Quick Methods to Merge Multiple Tasks into a Single One in Your Outlook

Outlook Data Recovery, Outlook Solutions April 16, 2018

Sometimes, you may need to merge multiple tasks into a single task. In the new task, the body contains all the bodies of all the source tasks and start date is the earliest date among all dates of the tasks and so on. Now, this article will teach you 2 ways.

When dealing with multiple Outlook tasks which are correlative to each other, you may want to directly merge them into one task. And the new merged task should include all the source tasks’ bodies and uses the earliest date among all dates as start date and latest date as due date and so on. Now, in the followings, we will introduce 2 means to quickly get it.

Method 1: Merge Multiple Tasks Manually

  1. In the first place, create a new task.
  2. Then, in the new task, turn to “Insert” tab and click “Outlook Items” button.
  3. Next, in the popup window, select the tasks you want to merge.
  4. And then select “Text only” option in “Insert as” box.Insert Tasks as Text Only
  5. After that, click “OK” button.
  6. Later, the information of the tasks will be inserted into the new task’s body.
  7. Now, you need to manually find the earliest and latest date among all dates in the body.
  8. Next, change the start and due date of the current task.Manually Change Start and Due Date
  9. Finally, save this task as usual.

Method 1 will be quite troublesome when setting the start date and due date of the merged task in that you have to manually find the earliest and latest date. In Method 2, you can thoroughly get rid of this trouble.

Method 2: Merge Multiple Tasks via VBA

  1. For a start, launch Outlook VBA editor according to “How to Run VBA Code in Your Outlook“.
  2. Then, add reference to “MS Excel Object Library” by reading “How to Add an Object Library Reference in VBA“.
  3. Later, copy the following code into a module.
Sub MergeMultipleTasksIntoOne()
    Dim objSelection As Outlook.Selection
    Dim objMergedTask As Outlook.TaskItem
    Dim objExcelApp As Excel.Application
    Dim objExcelWorkbook As Excel.Workbook
    Dim objExcelWorksheet As Excel.Worksheet
    Dim dStartDate As Date
    Dim dDueDate As Date
 
    Set objMergedTask = Outlook.Application.CreateItem(olTaskItem)
 
    Set objExcelApp = CreateObject("Excel.Application")
    objExcelApp.Visible = True
    Set objExcelWorkbook = objExcelApp.Workbooks.Add
    Set objExcelWorksheet = objExcelWorkbook.Sheets(1)
 
    Set objSelection = Outlook.Application.ActiveExplorer.Selection
    For i = 1 To objSelection.Count
        nLastRow = objExcelWorksheet.Range("A" & objExcelWorksheet.Rows.Count).End(xlUp).Row
        objExcelWorksheet.Cells(nLastRow, 1) = objSelection(i).StartDate
        objExcelWorksheet.Cells(nLastRow + 1, 1) = objSelection(i).DueDate
 
        objMergedTask.Body = objMergedTask.Body & objSelection(i).Body & vbCrLf & vbCrLf & "==================================" & vbCrLf & vbCrLf
 
        objMergedTask.Attachments.Add objSelection(i)
    Next
 
    'Get the Min and Max Date via Excel Function
    dStartDate = objExcelApp.WorksheetFunction.Min(Columns("A"))
    dDueDate = objExcelApp.WorksheetFunction.Max(Columns("A"))
 
    objMergedTask.StartDate = CDate(dStartDate)
    objMergedTask.DueDate = CDate(dDueDate)
    objMergedTask.Display
 
    objExcelWorkbook.Close False
    objExcelApp.Quit
End Sub

VBA Code - Merge Multiple Tasks into a Single One

  1. Next, add this macro to Quick Access Toolbar or ribbon.
  2. Finally, you can have a try.
  • First off, select the tasks to be merged.
  • Then, click the macro button.Merge Multiple Tasks via VBA
  • At once, a new task will display, which have all the original tasks’ bodies in body and uses the earliest date as start date, latest date as due date, as shown in the following screenshot.Merged Task from Multiple Tasks

Insist on Making Regular PST Backups

If you don’t want to lose your valuable Outlook data, it is recommended to make regular backups for your Outlook PST files. Only in this way, when suffering from PST corruption, you can get rid of difficult PST repair, which can be accomplished only via a robust tool, such as DataNumen Outlook Repair.

Author Introduction:

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair sql and outlook repair software products. For more information visit www.datanumen.com

Comments are closed.