Parsing to Access

[Guest]

I receive many e-mails daily with the following format (everything between
the asterisks):

************
This is an automated message from some web site

You are receiving this email because this listing is on your list. Visit the
web site to change your settings.

Location: STATE, United States
USERNAME completed EVENTNAME (EVENTTYPE) on DATECOMPLETED

Log Date: DATECOMPLETED
EVENTLOG

Visit this log entry at the below address:
EVENTLOGURL

....some other text which can be ignored...

************

The idea is to write to an Access table the following fields:
USERNAME, EVENTNAME, DATECOMPLETED, EVENTLOGURL

Currently I have a table in a database which I cut-and-paste this
information into. It would be extremely helpful to automate the process.

One complication is that 'completed' is not always the word there. It could
be 'didn't complete' or a few other phrases.

Anyhow, I have researched this and have come across a few pages which should
help:
http://www.outlookcode.com/codedetail.aspx?id=89
http://www.outlookcode.com/threads.aspx?forumid=2&messageid=696
http://www.outlookcode.com/threads.aspx?forumid=2&messageid=5609

Unfortunately, I have absolutely no experience writing VBA code. I have
fiddled with the examples, read through the beginner's section, etc. and have
gotten nowhere.

Can someone lend a helping hand? I am truly stuck on this and do not know
what to do at this point. I run Office 2003 Pro.

I appreciate anything you can do to help.

 

[Michael Bauer]

Please show us the code you have so far and tell us what or where the
problem (error) is.

--
Viele Grüße
Michael Bauer


"Frustrated with VBA" <Frustrated with (e-mail address removed)>
wrote in message
news:[email protected]...

 

[Guest]

Please show us the code you have so far and tell us what or where the
problem (error) is.

I attempted to use the code from
http://www.outlookcode.com/codedetail.aspx?id=89 and modify it. The reality
is that I have no idea what I am doing. I am hopeful someone can get me
going. What I am reading is way beyond my skill set.

 

[Jim Vierra]

Start by learning how to open an email message in a folder from inside of
Outlook. There are numerous examples on the Outlookcode.com website. Once
you have done this then learn to opena a connection to an Access database.
Next you will have to learn how to filter the messages and copy the fields
into Access. I suggest that this should take about one onth on a part time
basis or one week on a fulltime basis.

Bite the bullet - learn VBA coding! It's not so hard and it's invaluable to
managing large amounts of email.

 

[Michael Bauer]

In addition to Jim: Without following the link you´ve posted, I´m sure
that the *sample* works perfectly.

If you´ve modified it and now it doesn´t do what you want it to do, then
you need to post us your code, please, and describe your problem with
it.

--
Viele Grüße
Michael Bauer


"Frustrated with VBA" <[email protected]>
wrote in message