SOLVED

Importing Task List from Excel into Outlook

%3CLINGO-SUB%20id%3D%22lingo-sub-2379675%22%20slang%3D%22en-US%22%3EImporting%20Task%20List%20from%20Excel%20into%20Outlook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2379675%22%20slang%3D%22en-US%22%3E%3CP%3Ehello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20task%20list%20in%20Excel%20with%20Subject%2C%20Due%20Date%2C%20Categories.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20for%20VBA%20code%20to%20export%20my%20list%20in%20excel%20and%20import%20it%20into%20Oulook%20as%20Tasks.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20do%20this%3F%26nbsp%3B%20Thank%20you.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2394409%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20Task%20List%20from%20Excel%20into%20Outlook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2394409%22%20slang%3D%22en-US%22%3EI%20don't%20have%20a%20macro%20specifically%20for%20tasks%2C%20but%20have%20an%20example%20using%20calendar%20-%20it%20would%20be%20easy%20o%20change%20it%20for%20tasks.%20%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.slipstick.com%2Fdeveloper%2Fcreate-appointments-spreadsheet-data%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.slipstick.com%2Fdeveloper%2Fcreate-appointments-spreadsheet-data%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2396557%22%20slang%3D%22en-US%22%3ERe%3A%20Importing%20Task%20List%20from%20Excel%20into%20Outlook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2396557%22%20slang%3D%22en-US%22%3EHi%2C%20I%20have%20a%20follow%20up%20so%20thought%20would%20ask%20since%20you%20are%20quite%20knowledgeable.%20Do%20you%20know%20if%20there%20is%20functionality%20in%20Outlook%20to%20assign%20a%20calendar%20entry%20to%20a%20specific%20%22owner%22%3F%20Let%20me%20give%20an%20example.%20I%20have%20many%20calendar%20entries%20assigned%20to%20many%20people%20and%20I%20would%20like%20each%20%22owner%22%20to%20receive%20a%20notification%20or%20have%20it%20appear%20on%20their%20calendar.%20maybe%20this%20is%20not%20possible.%20thank%20you%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Frequent Contributor

hello,

 

I have a task list in Excel with Subject, Due Date, Categories.  

I am looking for VBA code to export my list in excel and import it into Oulook as Tasks.  

 

How can I do this?  Thank you.  

7 Replies
I don't have a macro specifically for tasks, but have an example using calendar - it would be easy o change it for tasks.
https://www.slipstick.com/developer/create-appointments-spreadsheet-data/
Hi, I have a follow up so thought would ask since you are quite knowledgeable. Do you know if there is functionality in Outlook to assign a calendar entry to a specific "owner"? Let me give an example. I have many calendar entries assigned to many people and I would like each "owner" to receive a notification or have it appear on their calendar. maybe this is not possible. thank you
You would delegate permissions and create the event on their calendar for them to be the owner of it.

Are you creating the events as meeting invitations? If you invite the person, they will be notified and a copy goes on their calendar.
Hi Diane,
sorry for my tardy reply. To answer your query, I dont think I would want to show as a meeting invitation because they could be confused if a month down the road they see a meeting invitation but it is not a meeting invitation. Not sure if that is confusing.

oh sorry, I should have said Tasks - you need to create it on their task list or assign the task (if you are all using the same exchange server).
Hi Diane, are you saying that I can assign a task to someone maybe through delegating like I would for calendar entries?
best response confirmed by Tony2021 (Frequent Contributor)
Solution
It's more like a meeting invite - you assign the task; they accept or decline it.

https://support.microsoft.com/office/assign-and-track-tasks-cdc1a3de-4e4c-44f6-8921-77a8cd43e971