I have a HUGE amount of Outlook emails that are in the same format, I need to transfer information to excel?

Question

I get about 100 emails a day and they are the exact same format, who they are from, the place they are asking about, any questions or comments, their name, their email, their phone number and then a couple of answers to questions we asked, one word answers. I would like to be able to transfer these over to excel into separate columns. I've tried exporting and it takes the whole body area into one column, which is better than what i have, but it doesn't take the whole context of the body, it's as if it will only export a certain number of characters. I have seen where you can write a macro, but that is way over my head. And I've also seen where people are saying to go into VBF and write there, but the directions are programming language way over my head. I'm using Office 2007. HELP!!! Thanks to all of you techie people!

Update:

Thanks Brayden. Unfortunately, some of the body of the outlook message are too many characters for the excel cell, otherwise that would work WONDERFUL! And I have to use excel not Word, because once I get done with this I have to upload it to Google docs for the whole company to be able to use, and when they do they need to be able to sort by different factors, not necessarily the same ones, but I do appreciate your answer, I will use the information you gave me in other projects!

Anonymous · Accepted Answer

You can try a macro program named Macro Expert, which can automatically transfer information to excel. Good luck!

brayden · Answer

Well, yes, you'd need to write some VBA code or a macro.

You say that exporting puts it into one column. Well in Excel there is a feature that will allow you to split data from one column into several. It is called "Text To Columns". In Excel 2007, you click "Data" on the ribbon and then in about middle of the ribbon you'll see "Text to Columns" (it's actually in the Data Tools section). Play around with that option and see if it will get you what you need. Otherwise, you will have to write some code or use a macro.

Unless it just has to be in Excel, you could also put it in Word. Outlook to Word would be seemless pretty much because of the lack of requirement for individual cells like in Excel. You could set your tabs up to align the data etc. I know at the office my users have this gigantic file they have to export from a web based program they use and then they have to format it in Word to get it to look right. Rather than spend hours reformatting it every single time they set themselves a macro for the formatting so they don't have to reformat every single time. You don't have to know code to record this kind of simple macro. A simple macro (like what they use) is like a tape recorder that records your steps. It's on the developer tab in Word. Then you'd click "record macro" --->it literally starts recording your every step. But it's a great feature if you have repetitive steps in a process cause it keeps you from having to constantly type over and over the same stuff. But, I am only saying this is an option IF you can use Word and IF you need to reformat your stuff once it gets into word.

bondieumatre · Answer

it in basic terms aint real. Ther's not a employer in the international that does this. Did you opt for for a activity interview? have you ever spoken to them a pair of activity in any respect? Why do not you pay for the lawyer your self? through fact its a rip-off. curiously i've got won over $2,000,000, been chosen for an spectacular activity, won the lottery, won a PS3 if I call this way (which for some reason costs $15 in line with minute), been chosen at random to get a loose holiday and could take earnings of African tax breaks. In each and every case, i could ought to deliver THEM funds OR supply MY ACCOUNT information. returned, sorry, yet they're all scams.

Trending News

I have a HUGE amount of Outlook emails that are in the same format, I need to transfer information to excel?

3 Answers