View Single Post
  #4  
Old October 15th 09, 06:46 PM posted to microsoft.public.outlook.program_vba
volda2000
external usenet poster
 
Posts: 1
Default move contents from hundreds of emails into excel

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:

Ads