[AccessD] Outlook and Access

It looks like running the whole thing from Access would be much easier 
and more reliable.  I could set it up to run on a trimer interval and go 
look at Outlook to see if any of the messages he's looking for are 
there.  But I think he wants the receipt of the email to trigger the 
code to push some data into access and then delete the email.

Rocky


Jim DeMarco wrote:
> You can (or could at least) link to an Outlook folder too if that's an
> option.  The data that shows in Access IIRC is not what you might expect
> though (sorry I can't be more clear but it's been quite a while since I
> tried that). 
>
>
> Jim
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
> Sent: Thursday, May 11, 2006 8:53 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Outlook and Access
>
> I know this probably won't help, but Rocky -- did you know that you can
> export messages into an Access database -- it's really a simple process.
> If you could filter those messages into a specific folder as they
> arrived, you could easily export the entire folder. I don't know what
> your client really needs, and certainly don't want to talk you out of
> any work, but sometimes the easy way really is enough. ;) This is
> something they wouldn't have to automate -- just do it -- would take a
> short phone call over the phone to show them how. If I remember
> correctly, you can't export into an existing database, so they'd also
> have to work through that, but again -- we're talking about a few
> minutes work to import the new messages from a temp db into the
> production db. 
>
> Susan H. 
>
> 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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.392 / Virus Database: 268.5.5/335 - Release Date: 5/9/2006
>  
>
> --
> 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