[AccessD] Outlook and Access

James:

Here's a two-step process - export from Outlook, import into Access.  
You might be able to handle the whole thing yourself this way.  Depends 
on how much automation you want for this function.

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