• Outlook User
  • New Outlook app
  • Outlook.com
  • Outlook Mac
  • Outlook & iCloud
  • Developer
  • Microsoft 365 Admin
    • Common Problems
    • Microsoft 365
    • Outlook BCM
    • Utilities & Addins

Assign one task to several people

Slipstick Systems

› Developer › Assign one task to several people

Last reviewed on September 8, 2016     19 Comments

When a task is assigned to one person, you can keep a copy of the task in your Task folder and the person who accepts the task can send you updates. However, this only works when you assign to the task to one person. If the Task is assigned to multiple people, Outlook can't track it and update the status.

Tasks sent ot a group can't be updated

In order to track the task and assign it to several people, you need to copy and resend the task.

Follow these steps to assign a task to a multiple people:

  1. Assign the task to the first person.
  2. Select the Assigned Task and Ctrl+C,V to copy and paste it.
  3. Select the copy and assign it to someone else.
  4. Repeat as needed.

While this works OK when you need to send the task to a small number of people, it's not workable to send it to a larger group.

To quickly assign a task to multiple people you need to use VBA. In this example, I'm using a userform to ask for the subject, due date and notes field and it's entered into the task.

  1. Set macro security to Low
  2. Open the VBA editor by press Alt+F11
  3. Right click on Project1 and choose Insert > Module
  4. Import the userform
  5. Paste the following code into the module

Select several contacts and run the macro to test it. Updated September 8 2016 to add an error handler. If contacts are not selected, the macro ends.

Public tSubject, tDate, tNotes As String

Public Sub SendTasksToGroup()
Dim Selection As Selection
Dim obj As ContactItem
Dim objTask As TaskItem
Dim objitem As Object
Set Selection = ActiveExplorer.Selection

Set objitem = Application.ActiveExplorer.Selection.Item(1)
If TypeOf objitem Is ContactItem Then
frmTask.Show
Else
MsgBox "you need to select one or more contacts"
Exit Sub
End If

For Each obj In Selection

 If obj.Class = olContact Then
  Set objTask = Application.CreateItem(olTaskItem)
        With objTask
                .Recipients.Add (obj.Email1Address)
                .Assign
                .Subject = tSubject
                .Body = tNotes
                .DueDate = tDate
                .Display
         End With
  End If
Next

Set objTask = Nothing
Set obj = Nothing
End Sub

If you want to edit the macro directly, you can replace tSubject, tDate, and tNotes with text. In the case of the date, you need to either use .DueDate = Now + 5 (or any whole number) or enter a date in this format: .DueDate = #1/2/2012#

Assign one task to several people was last modified: September 8th, 2016 by Diane Poremsky

Related Posts:

  • Create a Series of Tasks Leading up to an Appointment
  • Create a Series of Tasks using VBA
  • Create a Task and copy to another Tasks folder
  • Create a Task from an Email using a Rule

About Diane Poremsky

A Microsoft Outlook Most Valuable Professional (MVP) since 1999, Diane is the author of several books, including Outlook 2013 Absolute Beginners Book. She also created video training CDs and online training classes for Microsoft Outlook. You can find her helping people online in Outlook Forums as well as in the Microsoft Answers and TechNet forums.

Subscribe
Notify of
19 Comments
newest
oldest most voted
Inline Feedbacks
View all comments

Tammy (@guest_211017)
May 7, 2018 5:42 pm
#211017

Thank you for this info. I clicked a link in another post concerning the import of tasks from Excel, and ended up here. Hoping you may be able to provide some direction.

We have a large task list in Excel (155 tasks) that we want to be able to import into Outlook (right now, it is just a check-list, but frequently tasks are overlooked until after their due date). Some of the tasks will stay with the person the task list is being imported to, but several will need to be assigned to someone else, and tracked by the original owner. Is it possible to do this all at the same time as the task list is imported? I've tried mapping the assignment to "Role" and to "Contacts" without success. Any other suggestions?

Thank you!

0
0
Reply
Diane Poremsky(@diane-poremsky)
Author
Reply to  Tammy
May 9, 2018 12:19 am
#211018

You can't import it using the import wizard - it doesn't add the add the recipient, because it just saves; it won't send. A macro could do it - i have a macro at https://www.slipstick.com/developer/create-appointments-spreadsheet-data/#one that runs in excel (its faster to send to outlook, than for outlook to read excel) and creates appointments - you'd use the same basic idea for tasks, but change the field names (and use the tasks folder :)). i would use an if statement - if a field (the contact field) has an value, then assign and send it, else, just save it.

0
0
Reply
staphanie (@guest_204760)
February 21, 2017 1:42 am
#204760

Hi - Thank you for your post.

I am wanting to do something similar - assign multiple tasks to a single person.

Is it possible to adjust this coding to do this or do you have another suggestion on how to do this within Outlook?

Your time is much appreciated :-)

0
0
Reply
Diane Poremsky(@diane-poremsky)
Author
Reply to  staphanie
February 21, 2017 1:05 pm
#204782

This macro needs a little tweaking - since it's multiple tasks to one person, you remove the contact stuff and put the address in the recipient's line.
Public Sub SendTasks()
Dim Selection As Selection
Dim obj As TaskItem
Dim objTask As TaskItem
Set Selection = ActiveExplorer.Selection
For Each obj In Selection
If obj.Class = olTask Then
Set objTask = obj
With objTask
.Recipients.Add ("alias@domain.com")
.Assign
.Display
'.send
End With
End If
Next

Set objTask = Nothing
Set obj = Nothing
End Sub

0
0
Reply
Annette (@guest_204281)
February 3, 2017 2:48 pm
#204281

I like the idea of copying a task and resending to others. I don't get how to copy the task. Can you give more information please?

0
0
Reply
Diane Poremsky(@diane-poremsky)
Author
Reply to  Annette
February 21, 2017 12:56 pm
#204781

To copy it, select the task, ctrl+C to copy it then ctrl+v to paste it. This creates a new unassigned task, which you can assign to someone else.

0
0
Reply
Aj gillett (@guest_201230)
August 31, 2016 5:17 am
#201230

I am getting an error at line 11 in the code? Debugging highlights the line - For Each obj In Selection - any ideas on what the error might be?

0
0
Reply
Diane Poremsky(@diane-poremsky)
Author
Reply to  Aj gillett
September 8, 2016 12:34 pm
#201434

Does it say type mismatch? Do you have contacts selected? (I updated to code to add an error handler that verifies contacts are selected)

0
0
Reply
Chinua (@guest_199504)
June 20, 2016 3:30 am
#199504

How do you replace the tSubject, tDate, and tNotes with text? I tried it, but it still asked me to enter text for each contact.

0
0
Reply
Diane Poremsky(@diane-poremsky)
Author
Reply to  Chinua
September 8, 2016 12:23 pm
#201433

oops. frmTask.Show is out of position. It need to be before the loop. Sorry about that.

0
0
Reply
Dave Styles (@guest_195760)
January 4, 2016 7:31 am
#195760

Hi Diane, I am trying to use the above arrangement to assign tasks to several people in my organisation. I have followed your instructions but every time I try to save the file my copy of Outlook 2013 crashes. I have changed my macro settings to "Enable all macros" but still the same problem happens. However the macro seems to have saved but when I try to "run it" nothing happens.

0
0
Reply
Alan (@guest_194474)
November 4, 2015 6:23 pm
#194474

this is very helpful, im keen to try it soon but is there a way to link multiple emails to 1 task? eg if we get a quote request any of 3 people can do it and sometimes there might be multiple emails about the quote (from suppliers and the client) we would like to group them all together and be able to see when quote is finished by any of the 3 users.
is outlook up to this? or am i better off looking at a job ticketing system? we record quote details in an Access database and then do the quotes in excel. i dont want to open any more programs!

0
0
Reply
Diane Poremsky(@diane-poremsky)
Author
Reply to  Alan
January 6, 2016 12:42 am
#195807

I think a job ticketing system might be better. While outlook can group conversations or by sender, you'd need to manually add the messages to the tasks - it wouldn't be automatic.

0
0
Reply
Kam (@guest_191905)
July 15, 2015 7:13 am
#191905

Hi
I need to have more than recipient receiving the task automatic status notification
In the task details tab, the update list box is greyed out
What to do

0
0
Reply
Diane Poremsky(@diane-poremsky)
Author
Reply to  Kam
July 16, 2015 2:00 am
#191923

Are you generating the status notification using VBA or just clicking the update button?

0
0
Reply

Visit Slipstick Forums.
What's New at Slipstick.com

Latest EMO: Vol. 30 Issue 19

Subscribe to Exchange Messaging Outlook






Support Services

Do you need help setting up Outlook, moving your email to a new computer, migrating or configuring Office 365, or just need some one-on-one assistance?

Our Sponsors

CompanionLink
ReliefJet
  • Popular
  • Latest
  • Week Month All
  • Jetpack plugin with Stats module needs to be enabled.
  • Open Outlook Templates using PowerShell
  • Count and List Folders in Classic Outlook
  • Google Workspace and Outlook with POP Mail
  • Import EML Files into New Outlook
  • Opening PST files in New Outlook
  • New Outlook: Show To, CC, BCC in Replies
  • Insert Word Document into Email using VBA
  • Delete Empty Folders using PowerShell
  • Warn Before Deleting a Contact
  • Classic Outlook is NOT Going Away in 2026
Ajax spinner

Recent Bugs List

Microsoft keeps a running list of issues affecting recently released updates at Fixes or workarounds for recent issues in classic Outlook (Windows).

For new Outlook for Windows: Fixes or workarounds for recent issues in new Outlook for Windows .

Outlook for Mac Recent issues: Fixes or workarounds for recent issues in Outlook for Mac

Outlook.com Recent issues: Fixes or workarounds for recent issues on Outlook.com

Office Update History

Update history for supported Office versions is at Update history for Office

Outlook Suggestions and Feedback

Outlook Feedback covers Outlook as an email client, including Outlook Android, iOS, Mac, and Windows clients, as well as the browser extension (PWA) and Outlook on the web.

Outlook (new) Feedback. Use this for feedback and suggestions for Outlook (new).

Use Outlook.com Feedback for suggestions or feedback about Outlook.com accounts.

Other Microsoft 365 applications and services




New Outlook Articles

Open Outlook Templates using PowerShell

Count and List Folders in Classic Outlook

Google Workspace and Outlook with POP Mail

Import EML Files into New Outlook

Opening PST files in New Outlook

New Outlook: Show To, CC, BCC in Replies

Insert Word Document into Email using VBA

Delete Empty Folders using PowerShell

Warn Before Deleting a Contact

Classic Outlook is NOT Going Away in 2026

Newest Code Samples

Open Outlook Templates using PowerShell

Count and List Folders in Classic Outlook

Insert Word Document into Email using VBA

Warn Before Deleting a Contact

Use PowerShell to Delete Attachments

Remove RE:, FWD:, and Other Prefixes from Subject Line

Change the Mailing Address Using PowerShell

Categorize @Mentioned Messages

Send an Email When You Open Outlook

Delete Old Calendar Events using VBA

VBA Basics

How to use the VBA Editor

Work with open item or selected item

Working with All Items in a Folder or Selected Items

VBA and non-default Outlook Folders

Backup and save your Outlook VBA macros

Get text using Left, Right, Mid, Len, InStr

Using Arrays in Outlook macros

Use RegEx to extract message text

Paste clipboard contents

Windows Folder Picker

Custom Forms

Designing Microsoft Outlook Forms

Set a custom form as default

Developer Resources

Developer Resources

Developer Tools

VBOffice.net samples

SlovakTech.com

Outlook MVP David Lee

Repair PST

Convert an OST to PST

Repair damaged PST file

Repair large PST File

Remove password from PST

Merge Two Data Files

Sync & Share Outlook Data

  • Share Calendar & Contacts
  • Synchronize two computers
  • Sync Calendar and Contacts Using Outlook.com
  • Sync Outlook & Android Devices
  • Sync Google Calendar with Outlook
  • Access Folders in Other Users Mailboxes

Diane Poremsky [Outlook MVP]

Make a donation

Mail Tools

Sending and Retrieval Tools

Mass Mail Tools

Compose Tools

Duplicate Remover Tools

Mail Tools for Outlook

Online Services

Calendar Tools

Schedule Management

Calendar Printing Tools

Calendar Reminder Tools

Calendar Dates & Data

Time and Billing Tools

Meeting Productivity Tools

Duplicate Remover Tools

Productivity

Productivity Tools

Automatic Message Processing Tools

Special Function Automatic Processing Tools

Housekeeping and Message Management

Task Tools

Project and Business Management Tools

Choosing the Folder to Save a Sent Message In

Run Rules on messages after reading

Help & Suggestions

Submit Outlook Feature Requests

Slipstick Support Services

Buy Microsoft 365 Office Software and Services

Visit Slipstick Forums.

What's New at Slipstick.com

Home | Outlook User | Exchange Administrator | Office 365 | Outlook.com | Outlook Developer
Outlook for Mac | Common Problems | Utilities & Addins | Tutorials
Outlook & iCloud Issues | Outlook Apps
EMO Archives | About Slipstick | Slipstick Forums
Submit New or Updated Outlook and Exchange Server Utilities

Send comments using our Feedback page
Copyright © 2025 Slipstick Systems. All rights reserved.
Slipstick Systems is not affiliated with Microsoft Corporation.

wpDiscuz

Sign up for Exchange Messaging Outlook

Our weekly Outlook & Exchange newsletter (bi-weekly during the summer)






Please note: If you subscribed to Exchange Messaging Outlook before August 2019, please re-subscribe.

Never see this message again.

You are going to send email to

Move Comment