[AccessD] Outlook and Access

Yes there's a drop down.  Choose "Application" from the left side and
NewMail from the list on the right.

I'll send it in a sec. 


Jim

-----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 9:24 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Outlook and Access

Jim:

I'd be grateful for a copy.  You could send it offline -
bchacc at san.rr.com. Is there a property sheet with event properties to
set the event in Outlook like there is in Access?  Or how does the event
get triggered in Outlook?

TIA

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