[AccessD] Outlook and Access

Susan:

I forwarded your suggestion to the client.  He's got a little bit of 
facility with Access and might find this solution practical.  I don't 
know how much he wants this function to be automated.

Rocky


Susan Harkins wrote:
> 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
>  
>
>   

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