[AccessD] Outlook and Access

If someone knew what they were doing, about how many hours do you think 
it would take - 1? 2-4? 5-10?

(anybody feel free to chime in here)

Rocky


Jim DeMarco wrote:
> Rocky,
>
> We had some code on our admin's Outlook that took a help desk e-mail
> with a certain subject and inserted it in an Access database.  It's
> triggered by Outlook's Application_NewMail event but I have to warn you
> it's very inconsistent (at least it was here).  On occasion (more
> frequently than occasionally) it missed items.  The code is the same
> code you'd use to insert a record in Access from any system (Excel, web,
> etc.) the only difference is when the NewMail event triggers you read
> the new message's subject to determine what to do.
>
> We ended up disabling or removing the code from Outlook when we moved to
> Track-It to handle these requests.  I have the code if you'd like to
> take a look (1 class module, 1 standard module, then Outlook code
> althought I do believe we ended up moving the class code right into
> NewMail event out of frustration).
>
>
> Jim DeMarco
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
> - Beach Access Software
> Sent: Thursday, May 11, 2006 1:22 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Outlook and Access
>
> Dear list:
>
> I have a request from a client to program something in Outlook but I
> have no idea where to start.  Quote:
>
> "If an email comes in with a 6 digit (alphanumeric) code in the Subject
> line, Outlook would make a call to Access, passing along the code and
> then delete the email.  No code, email automatically deleted.  The call
> to access would cause the code to be looked up and a status report
> emailed to the client if the code is current. "
>
> I suppose the receipt of any email would have to trigger this hunk of
> code. 
>
> I've put a lot of code behind Excel sheets to push data into an Access
> database but never from Outlook.  Does anyone know of any code samples,
> snips, explanations, etc. that could get me started on this?
>
> MTIA,
>
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.e-z-mrp.com
>
>
>
> --
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.e-z-mrp.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com