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 ?

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 ?

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 !

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 !