<div>
Hello Karl, 
 
I would like to tell you that Outlook does not export custom fields or user defined fields but you can do the rest of the thigns by following given method. 
 
Open Outlook and follow the given instructions: 
 
File &gt;&gt;&nbsp;Open &gt;&gt;&nbsp;Import &gt;&gt;&nbsp;Export to a File (Next) &gt;&gt;&nbsp;Comma Seperated Values (Windows - Next) &gt;&gt;&nbsp;Tasks (Next) &gt;&gt;&nbsp;Browse (to save CSV file) &gt;&gt;&nbsp; 
 
Feel free to ask further!!! 
 
Regards 
Clark Kent
</div>

<div>
you can manipulate task fields information with VBA. 
 
BlueDevilFan has answered similar question on EE link is here <a href="https://www.experts-exchange.com/questions/23533230/VBA-to-export-Outlook-Tasks-to-Excel-worksheet.html" rel="ugc">https://www.experts-exchange.com/questions/23533230/VBA-to-export-Outlook-Tasks-to-Excel-worksheet.html</a> 
 
he also has a <a href="https://techniclee.wordpress.com/2013/02/15/exporting-outlook-tasks-to-excel/" rel="ugc">blog</a> with very useful code exporting tasks from outlook to excel
</div>

<div>
this is also another way to do it. 
 
 
Select the tasks you want export in excel. (If you want to export all tasks then press &quot;ctrl + A&quot;) to select all tasks in your tasks folder and then drag it to excel or you can copy (Ctrl + C) go to excel sheet and paste it there (Ctrl + v). 
 
Best,
</div>

<div>
Hi ProfessorJimJam, 
 
I tried to export my own tasks field, but It doesn't work. 
 
Do you know if it's possible ? 
 
Thanks, 
Carol
</div>

<div>
Hi, 
 
The code is amended it will work. please copy the code and open outlook click (Alt + F11) insert a module and paste it. 
 
The file will be saved in your desktop, File name Outlook Tasks. 
 
before you run the code please ensure that microsoft Excel 14.0 object library is ticked as shown in the screen shot. to check click Tools--References .<a href="https://filedb.experts-exchange.com/incoming/2015/12_w49/1048456/Microsoft-excel.PNG" target="_blank" title="Microsoft-excel.PNG (25 KB)"><img alt="Microsoft-excel.PNG" class="file-block lazyload" style="max-width: 451px;" data-src="https://filedb.experts-exchange.com/incoming/2015/12_w49/1048456/Microsoft-excel.PNG" /></a> 
 
 
[ Sub ExportTasks2Excel() 
&nbsp; &nbsp; Dim olkFolder As Outlook.MAPIFolder, _ 
&nbsp; &nbsp; &nbsp; &nbsp; olkList As Outlook.Items, _ 
&nbsp; &nbsp; &nbsp; &nbsp; olkTask As Outlook.TaskItem, _ 
&nbsp; &nbsp; &nbsp; &nbsp; excApp As Object, _ 
&nbsp; &nbsp; &nbsp; &nbsp; excBook As Object, _ 
&nbsp; &nbsp; &nbsp; &nbsp; excSheet As Object, _ 
&nbsp; &nbsp; &nbsp; &nbsp; intRow As Integer, _ 
&nbsp; &nbsp; &nbsp; &nbsp; strQuery As String 
&nbsp; &nbsp; Set excApp = CreateObject(&quot;Excel.Application&quot;) 
&nbsp; &nbsp; Set excBook = excApp.Workbooks.Add 
&nbsp; &nbsp; Set excSheet = excBook.ActiveSheet 
&nbsp; &nbsp; intRow = 1 
&nbsp; &nbsp; Set olkFolder = Session.GetDefaultFolder(olFolderTasks) 
&nbsp; &nbsp; strQuery = &quot;[DueDate] &gt;= '6/1/2008' AND [DueDate] &lt;= '12/31/2010'&quot; 
&nbsp; &nbsp; Set olkList = olkFolder.Items.Restrict(strQuery) 
&nbsp; &nbsp; For Each olkTask In olkList 
&nbsp; &nbsp; &nbsp; &nbsp; excSheet.Cells(intRow, 1) = olkTask.Subject 
&nbsp; &nbsp; &nbsp; &nbsp; excSheet.Cells(intRow, 2) = olkTask.BillingInformation 
&nbsp; &nbsp; &nbsp; &nbsp; excSheet.Cells(intRow, 3) = olkTask.TotalWork 
&nbsp; &nbsp; &nbsp; &nbsp; excSheet.Cells(intRow, 4) = olkTask.StartDate 
&nbsp; &nbsp; &nbsp; &nbsp; excSheet.Cells(intRow, 5) = olkTask.DueDate 
&nbsp; &nbsp; &nbsp; &nbsp; excSheet.Cells(intRow, 6) = olkTask.Categories 
&nbsp; &nbsp; &nbsp; &nbsp; excSheet.Cells(intRow, 7) = olkTask.Role 
&nbsp; &nbsp; &nbsp; &nbsp; excSheet.Cells(intRow, 8) = olkTask.Body 
&nbsp; &nbsp; &nbsp; &nbsp; intRow = intRow + 1 
&nbsp; &nbsp; Next 
&nbsp; &nbsp; 'Change the file path and name on the following line 
&nbsp; &nbsp; On Error Resume Next 
&nbsp; &nbsp; excBook.SaveAs &quot;\\C:\Users\Public\Desktop\Outlook task.xlsx&quot; 
&nbsp; &nbsp; excBook.Close False 
&nbsp; &nbsp; Set excSheet = Nothing 
&nbsp; &nbsp; Set excBook = Nothing 
&nbsp; &nbsp; Set excApp = Nothing 
&nbsp; &nbsp; Set olkTask = Nothing 
&nbsp; &nbsp; Set olkList = Nothing 
&nbsp; &nbsp; Set olkFolder = Nothing 
End Sub 
]
</div>

Microsoft-excel.PNG

<div>
<pre><code class="code-10 nolinks" id="code-8283981">'The file path is changed to user account: &quot;C:\Documents and Settings\&quot; &amp; UID &amp; &quot;\Outlook Tasks.xls&quot; ' UID = User ID.

Sub ExportTasks2Excel()
 Dim olkFolder As Outlook.MAPIFolder, _
 olkList As Outlook.Items, _
 olkTask As Outlook.TaskItem, _
 excApp As Object, _
 excBook As Object, _
 excSheet As Object, _
 intRow As Integer, _
 strQuery As String
 Set excApp = CreateObject(&quot;Excel.Application&quot;)
 Set excBook = excApp.Workbooks.Add
 Set excSheet = excBook.ActiveSheet
 intRow = 1
 Set olkFolder = Session.GetDefaultFolder(olFolderTasks)
 strQuery = &quot;[DueDate] &gt;= '6/1/2008' AND [DueDate] &lt;= '12/31/2010'&quot;
 Set olkList = olkFolder.Items.Restrict(strQuery)
 For Each olkTask In olkList
 excSheet.Cells(intRow, 1) = olkTask.Subject
 excSheet.Cells(intRow, 2) = olkTask.BillingInformation
 excSheet.Cells(intRow, 3) = olkTask.TotalWork
 excSheet.Cells(intRow, 4) = olkTask.StartDate
 excSheet.Cells(intRow, 5) = olkTask.DueDate
 excSheet.Cells(intRow, 6) = olkTask.Categories
 excSheet.Cells(intRow, 7) = olkTask.Role
 excSheet.Cells(intRow, 8) = olkTask.Body
 intRow = intRow + 1
 Next
 'Change the file path and name on the following line
 UID = Environ(&quot;Username&quot;)
 
 
 excBook.SaveAs &quot;C:\Documents and Settings\&quot; &amp; UID &amp; &quot;\Outlook Tasks.xls&quot;
 
 excBook.Close False
 Set excSheet = Nothing
 Set excBook = Nothing
 Set excApp = Nothing
 Set olkTask = Nothing
 Set olkList = Nothing
 Set olkFolder = Nothing
End Sub
</code></pre>
</div>

<div>
Hi, 
 
I &nbsp;tested BlueDevilFan code gave by ProfessorJimJam, and it works. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
Excel amusant, it’s the same code as yours. 
 
My problem is the result, I got only default task fields ( subject, billinginformation, ...) and not my custom &nbsp;field. 
 
As an example, I created &nbsp;&quot;ProjectName&quot; custom field task. 
In the code, I added the line: &nbsp; &nbsp; excSheet.Cells(intRow, 9) = olkTask.ProjectName 
 
And it doesn’t work, I got all others fields but not my custom field.
</div>

<div>
Yeh! you made my day 
 
Now I got in the exportation my custom field. 
 
Thanks
</div>

<div>
<div class="content wysiwyg-content">
Hi, 
I tried to export outlook task in Excel by “File-Export option”. 
But the field I created are not exported. 
How can I export to excel, or import from excel all outlook task fields? 
Thanks 
Carol
</div>
</div>

Hi,
I tried to export outlook task in Excel by “File-Export option”.
But the field I created are not exported.
How can I export to excel, or import from excel all outlook task fields?
Thanks
Carol

Export outlook task to Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note-taker, journal, and web browser.

Outlook

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.