Pulling Information from Email for Reports.

[tribear]

Hi All,

I am the chairman of a professional group at NCPMI and our website allows members to register for meetings. The web engine sends me conformations (copied) to me but I can not export data to a list from those emails to create a sign up sheet the day of the meeting. I am not a script writer but willing to learn. I need some script ideas or help writing one.

Below is the important stuff to capture from each email I have filtered into a Zimbra folder:


Registration Confirmed For:</strong>name is here</td>
PMI Number:</strong> number is here</td>
Primary Email:</strong>email address is here</td>
Date: </strong>January 19, 2011 - Wednesday</td>
Event Title:</strong>A title here</td>


Hopefully the results could be viewed in Word or Excel so I can print a signup sheet for those who show up.

Any guidance would be appreciated.

Tribear

[Dirk]

Sounds like it may be easier to get the data directly from the SQL server. If the signups are being done at a webpage and then emailed to you, it's likely that they are being stored somewhere. And if they are not, then they can be. I dont think that creating a printed signin sheet for this data is a suitable task for an email client, I'd place it more as an extension of your web application.

Is an enhancement to your web page possible?

[tribear]

Thanks Dirk,

Your right! The web application should be doing this for me. I've been frustrated by the lack of reporting from our site and thought I'd just do it myself - directly from my mail server _ Zimbra (open source)