Forum Discussion
Solved
Importing Task List from Excel into Outlook
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.
- 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
- 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.
