View Single Post
  #1  
Old October 1st 09, 09:07 PM posted to microsoft.public.outlook.program_vba
JSpence2003
external usenet poster
 
Posts: 3
Default move contents from hundreds of emails into excel

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:
Ads