importing info from an email
 

I have around 1000 emails in outlook that all follow the same format that i
would like to import into excel so i can analyse them
Exporting it out is the easy bit - but when its there all the info in the
email appears like this :
"A visitor at aqua gas has left the following information
Name: Users name
Email: Users email
User commented:
Users address

Send Date: 19/08/2005 14:46:15

"
All the info is on seperate lines so when i try to get each bit of info into
a seperate column nothing seems to work as the text to column action can't
deal with seperate lines within a row.

anyone got any ideas ?

importing info from an email
 

You will need VBA to analyses the text and break it out into columns. Can you
provide details of what you want as output (data and format/columns). Is the
example all the data from an e-mail?

"aquagas" wrote:

I have around 1000 emails in outlook that all follow the same format that i
would like to import into excel so i can analyse them
Exporting it out is the easy bit - but when its there all the info in the
email appears like this :
"A visitor at aqua gas has left the following information
Name: Users name
Email: Users email
User commented:
Users address

Send Date: 19/08/2005 14:46:15

"
All the info is on seperate lines so when i try to get each bit of info into
a seperate column nothing seems to work as the text to column action can't
deal with seperate lines within a row.

anyone got any ideas ?

importing info from an email
 

The example given was the example of the body text from the email yes
(its an email i get sent every time someone registers on our website)
I'd like it to have:
1 column saying the users name,
1 column saying the users email,
1 column saying the users commented (company name or address),
1 column saying the date,

What is VBA ?

any help is greatfully recieved - thank you !

importing info from an email
 

VBA is Visual Basic (for Applications) which is a programming language. I
have written some code so could you mail me a sample workbook containing
several e-mails so I can test it?

)

"aquagas" wrote:

The example given was the example of the body text from the email yes
(its an email i get sent every time someone registers on our website)
I'd like it to have:
1 column saying the users name,
1 column saying the users email,
1 column saying the users commented (company name or address),
1 column saying the date,

What is VBA ?

any help is greatfully recieved - thank you !