Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Export Outlook Data to Excel
Name: bellde Date: September 24, 2008 at 07:38:08 Pacific OS: XP - Office 2002 CPU/Ram: Unknown Product: Dell
Comment:
I'm wondering if there's any way to export data that is being emailed to me, into an Excel spreadsheet, or Access database?
Name: Jennifer SUMN Date: September 24, 2008 at 07:41:11 Pacific
Reply:
What data? Email attachments? If so, what filetypes? Outlook emails? Contacts? You need to be more specific.
"So won’t you give this man his wings What a shame To have to beg you to see We’re not all the same What a shame" - Shinedown
0
Response Number 2
Name: bellde Date: September 24, 2008 at 08:09:04 Pacific
Reply:
It's a list of data that's in the body of an Outlook email - I know I can copy and paste, but I was wondering if there was some way that it could just "do it"..... Am I dreaming?
0
Response Number 3
Name: Jennifer SUMN Date: September 24, 2008 at 16:04:49 Pacific
Reply:
This will take a little work. Open Notepad, copy and paste the data to the open notepad window, separate the items by a comma or a tab. Then, save the file as a csv file and open it from Excel.
If the data is already in a list, with a hard return between each entry, you won't have to use the commas. If there is more than one word on each line, and you want those words to be in separate fields in Excel, then you will have to insert a comma between each one, or enter a hard return after each one after pasting into Notepad.
"So won’t you give this man his wings What a shame To have to beg you to see We’re not all the same What a shame" - Shinedown
0
Response Number 4
Name: Jennifer SUMN Date: September 30, 2008 at 07:23:26 Pacific
Reply:
So did that work?
"So won’t you give this man his wings What a shame To have to beg you to see We’re not all the same What a shame" - Shinedown
Summary: I’ve been trying to import some tasks that I have access to but that aren’t my tasks into an Excel file. I want to be able to do this with a "shared task" located in one of my "public folders" so ...
Summary: I am exporting my emails from Outlook to excel, and it is almost fine, but the date (received/sent) doesn't come along. Only these fields: Subject Body FromName FromAddress FromType ToName ToAddress T...
Summary: Hi there, I want to push specific data from a selected contact in Outlook 2003 to a predefined Excel 2003 spreadsheet. The scenario is that I want a naive user to enter data into a new contact in outl...
0 
