[AccessD] Outlook and Access

Shouldn't take long at all really. 

Should mention that if Outlook 2003 the security warnings may be an
issue although you're not sending mail.  I seem to recall we might have
had an issue with that (because there was code running in an Outlook
session).  There's always ClickYes for that.


Jim DeMarco

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
DWUTKA at marlow.com
Sent: Thursday, May 11, 2006 11:48 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Outlook and Access

Knew what they were doing?  30 minutes, depending on how fast you type.

Drew

-----Original Message-----
From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
Sent: Thursday, May 11, 2006 10:25 AM
To: Access Developers discussion and problem solving
Subject: Re: [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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com