[AccessD] Outlook and Access

I noticed that NewMailEx event when I went snooping into Outlook VBA
this AM.  That may have done the trick for us.


Jim

-----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:23 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Outlook and Access

What version of Outlook is your client using?  Outlook 2003 has
NewMailEx as an event, which will handle multiple incoming email events.
The help file has sample code on how to 'capture' the new email coming
in, and then you are simply dealing with working with an .mdb through
VBA.

However, you mentioned that you wanted to delete the emails that don't
have a proper code, so am I to assume that this is not a 'users' email
address?
If it's not, you would need a machine dedicated to running Outlook for
an 'unused' email address.  What would work better there would be a
service running on their mail server.  Are they using an Exchange mail
server?  The service could just monitor that account, and do what you
want.  I have built services like that before.

Drew

-----Original Message-----
From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
Sent: Thursday, May 11, 2006 12: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