hi all

just a thought if the body text is divided up by colons you might want to
look at split

BodyArray=split(Myitem.body,":")

this will give you array each element will be the text between the colons

regards



Pete

"volda2000" wrote:

I have just been tasked with the same request. Were you able to get this to
work?

"JSpence2003" wrote:

I have hundreds of emails that got forwarded from a web form to my email
account. Each email has the same body contents, in that they all have this
basic format below (with different data after each colon). I would like to
try to get a script that can go though this folder, and take the data the
people provided and place it all into Excel rows/columns at one time.
Currently, I copy/paste it into Excel, then I have a macro that takes it from
its current format and moves the data into appropriate fields. This is great,
but can only be done, one email at a time.

Any suggestions?

Add_to_BW_Email_List:
Anniversary_Day:
Anniversary_Month:
BirthdayDay:
Birthday_Month:
address:
city:
email:
name:
state:
submit:
zip: