When you assign a task, if you fill in multiple recipients and click “Send”, you will receive a warning telling that the task sent to many persons will not be updated. Thus, if you want to get task updates in time, you’d better assign the task to many recipients separately.Warning about No Task Update

Of course, aside from the consideration of task update, due to confidentiality, you need to send a task to multiple persons separately. Generally, you have to create separate tasks, add recipient and send one by one. It is obviously troublesome. So, in the followings, we will introduce you a much more efficient way.

Batch Assign a Task to Multiple Persons Separately

  1. For a start, press “Alt + F11” to access Outlook VBA editor.
  2. Next, in the “Microsoft Visual Basic for Applications” window, copy the VBA code into a blank module or project.
Sub AssignTaskToMultipleContactsSeparately()
    Dim objCurrentTask As Outlook.TaskItem
    Dim objRecipients As Outlook.Recipients
    Dim objRecipient As Outlook.Recipient
    Dim objCopiedTask As Outlook.TaskItem
    Dim i As Long
    Dim strRecipientName As String
 
    Set objCurrentTask = Outlook.Application.ActiveInspector.CurrentItem
 
    If Not objCurrentTask Is Nothing Then
       Set objRecipients = objCurrentTask.Recipients
 
       For Each objRecipient In objRecipients
           Set objCopiedTask = objCurrentTask.Copy
 
           For i = objCopiedTask.Recipients.Count To 1 Step -1
               objCopiedTask.Recipients.Remove (i)
           Next
 
           strRecipientName = Split(objRecipient.Address, "@")(0)
           strRecipientName = UCase(Left(strRecipientName, 1)) & Right(strRecipientName, Len(strRecipientName) - 1)
 
           With objCopiedTask
                .Recipients.Add (objRecipient.Address)
                .Recipients.ResolveAll
                .Subject = .Subject & " (" & strRecipientName & ")"
                .Assign
                .Send
          End With
        Next
 
        objCurrentTask.Close olDiscard
    End If
End Sub

VBA Code - Batch Assign a Task to Multiple Persons Separately

  1. Subsequently, add this macro to the ribbon of Task window by referring to “Optional Step” in the post – “How to Run VBA Code in Your Outlook“.
  2. Eventually, take the following steps to try this macro.
  • Firstly, create a new task and add the recipients at will.
  • Then, click the macro button in ribbon.Run Macro on Current Task
  • At once, the current task will be assigned to the recipients separately, as shown in the following screenshot.Separate Assigned Tasks