Estimated time for this job (Outlook 2003)

[Mark B]

I have a user who has requested to get the following code done and was
wondering how long I could expect it to take given that I haven't done
Outlook programming before.

(I have done thousands of hours coding in other VBA and VB projects though)

Outlook 2003 Request:

1) Intercept incoming emails that are to a specific email address and move
them to a specific folder
2) Extract email field values such as From, Subject, Body and append that
data to an external Access 97 table
(http://www.orbisoft.com/kb/taskmanager/2007/q/1050.htm)
3) Send back a confirmation email after picking up the (Orbisoft) Task ID
field value from the appended record.

Big job?

Methodology for appending to the Access table?

TIA
Mark

 

[Michael Bauer [MVP - Outlook]]

With some already existing (and debugged) code templates, I'd say about four
hours. The one does it in three, the other in five. Often an options dialog
gets added to the request at a later time, that might or might not add an
hour.

Without that templates you will most likely need more time. That depends on
how good you are in getting the necessary informations, and on your
programming skills, of course.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
Organize eMails:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>

Am Thu, 25 Oct 2007 14:16:54 +1300 schrieb Mark B:

 

[Mark B]

Thank you Michael.

With some already existing (and debugged) code templates, I'd say about four
hours. The one does it in three, the other in five. Often an options dialog
gets added to the request at a later time, that might or might not add an
hour.

Without that templates you will most likely need more time. That depends on
how good you are in getting the necessary informations, and on your
programming skills, of course.