Outlook 2007 Export tasks to Excel

Status
Not open for further replies.

Tom Randall

New Member
Outlook version
Outlook 2007
Email Account
Exchange Server 2010
Hi All,

I'm wondering if any one can help me on a little issue I have. I'm using Sharepoint tasks linked to Outlook to enable my colleagues to track projects they are working on. I need to export the task information in to Excel but unfortunately "File>Import and Export>Export to a file" option only pulls a few lines of the task content not the full details. Does any one know a better way to extract this information?

Many thanks,

Tom
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Are you exporting as CSV or Excel (XLS file)? CSV should include the full body, but it may not open correctly in Excel (it will split into multiple rows). I'm not sure if it will help if you open the csv in notepad and add quotes around the body field, but is worth a try.
 

Tom Randall

New Member
Outlook version
Outlook 2007
Email Account
Exchange Server 2010
Hi Diane,

Exporting as a CSV instead of an XLS works brilliantly.

Thanks for your help.

Tom
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
L Outlook 2007 Codes Export and Import Using Outlook 9
L Outlook 2007 Toolbar Export and Import Using Outlook 7
K outlook 2007 Export/Import Distribution lists Using Outlook 1
W can't export Outlook 2007 mail after trial Using Outlook 2
R Can I export/import emails from Windows Live Mail into Outlook 2007 (not on an exchange server)? Using Outlook 1
J Unable to export Outlook 2007 data to Excel or Access Using Outlook 4
A Unable to export contacts to PST in Outlook 2007 with Win 7 Ultimate (64 bit) Using Outlook 4
E how do i export my contact list from yahoo to outlook 2007 Using Outlook 2
J export outlook 2007 contacts to avery business card templates or word Using Outlook 1
M outlook 2007 import export button is gray Using Outlook 7
J MS Outlook 2007 to 2010 - Use Import/Export? Using Outlook 0
L How do I export Outlook 2007 emails (not by forwarding) back to my Yahoo.com email account/server so I can access my emails remotely? Using Outlook 8
S Verwendung von Outlook 2007 Using Outlook 0
A Arthur needs help with 2007 Outlook e-mail Using Outlook.com accounts in Outlook 3
M PST import from Outlook 2007 to 2010 - Address Book contacts all in 1 group Using Outlook 4
S outlook 2007 calendar search Using Outlook 6
B Migrate Outlook 2007 to Office 365 Using Outlook 3
X I have met my waterloo trying to resolve embedded graphics problem with outlook 2007 and now 2016 Using Outlook 1
R Outlook 2007 only loads some appointments Using Outlook 0
C Move Outlook 2007 to new PC with Outlook 365 Using Outlook 3
J Outlook 2007 Hide Messages Option not Available Using Outlook 2
S Outlook 2007 Calendar instant search problem. Windows 7 Using Outlook 4
S Outlook 2007 Calendar instant search problem. Windows 7 Using Outlook 0
B Server errors Outlook 2007 Using Outlook 1
S Reboot of frozen windows7 results in changed outlook 2007 settings Using Outlook 1
S Outlook 2007 printing wrong email address at top of page Using Outlook 8
M Configure outlook 2007 to accept digital signatures Using Outlook 2
D Outlook 2007 crashes when opening an email Using Outlook 2
R New chap saying hello and needing advice on Outlook 2007 thumbnails Using Outlook 3
icacream From Outlook 2007 to 2016 ! Using Outlook 9
vodkasoda Object could not be found Error in Outlook 2007 Outlook VBA and Custom Forms 5
S Outlook 2007: Address Cards allow entering text! Why? Using Outlook 3
S View Appointment in Text Wrap in Outlook 2007 Month Calendar View Using Outlook 0
L Outlook 2007 Separate the Send/Receive functions Using Outlook 2
M Outlook 2007 Contacts Glitch: Creating a new email Using Outlook 1
C Move from Outlook 2007 Enterprise (MOE) to Outlook Pro plus 2007 Using Outlook 1
J reinstalling Outlook 2007 asking for user name & password Using Outlook 14
P outlook addin unloaded in office 2007 Using Outlook 0
B Fonts in Outlook 2007 Using Outlook 4
R Add Exchange Account to existing POP3 Outlook 2007 Profile Using Outlook 0
C out of space in file group Outlook 2007 Using Outlook 2
A Moving archived contents in Outlook 2007 back into working folders Using Outlook 0
P Outlook 2007 Email Categorization using VBA Outlook VBA and Custom Forms 1
M Unable to Configure Gmail Account in Outlook 2007 Using Outlook 1
R Outlook 2007 or 2010 - Lock Down Functionality Outlook VBA and Custom Forms 3
S Outlook 2007, windows 10 Font size Using Outlook 1
Diane Poremsky Manually create a POP3 account in Outlook 2007 New Slipstick.com Articles 0
J Can Click to Drag Custom Form Field But Cannot Drop When Designing in Outlook 2007 Outlook VBA and Custom Forms 2
L Outlook 2007 Font Using Outlook 3
J Outlook 2007 connector and Windows 10 Using Outlook 3
Similar threads


















































Top