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 ?