Email programming

[WOTR]

How shall we updload recordset through email?

[Cakkie]

Well, you will need to write a program that collects the emails, parse them, and processes them. I think there are two possible ways

1) the hard way. You write a program that connects to the email server, retrieves the emails, and parses them. This is called the hard way because you will need to program the email stuff yourself (although it isn't that hard, you just need to know the email commands and you will need to work with winsock to do this)

2) the easy way, i'm not sure there really is an easy way, but this is the easiest way. You let outlook collect the mails, and you just process them. This can be done using the outlook typelibrary. You will need to use the mailitem object; With this object, you can get about everything you need from the email (like subject, sender, body, attachments,...). Once you got the data you need, you must parse that and take appropriate actions (like updating the recordset)

The first way requires the most skills, but gives you more control over the situation. The second way requires less skills, but doesn't give you full control, and the computer running that program must have outlook configured and running.

Tom Cannaerts
slisse@planetinternet.be

Programming today is a race between software engineers striving to build bigger and better idot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook