[AccessD] Automating Outlook from Access

[John Colby]

Yep.  Until the web site goes down, the database corrupts, gets hacked,  or
a million other problems that web sites have.

My intent is that a client makes a purchase and a few minutes later his
purchase pops into his mail box.  An easy (for me) way to do that is
receive an order email from my server every time an order is placed.

A lot of folks aren't comfortable with classes, so if that is the case
there are a dozen ways to skin a cat.  I have automated Office for 25
years, excel, word, Access itself, and now outlook.  If that is "my only
tool" ... I guess I'll have to ask Microsoft why they bothered giving us
events and event driven programming. Or are we referring to using classes?
Hmmm I'll ask Microsoft why every object in every office app is a class.

I suppose I could use power shell and poll the database.... "Real men" and
all that!🤔😎

Believe it or not I used to do extensive programming in DR Dos back in the
day.  Turbo Pascal for many years before that.  Zapple basic back in 1977.
Ahhh the good old days.  RTos on a Z80 sbc for a few years in the 90s.  C#
automating SQL Server for several years in the 2010 time frame.

Well, hmmm, not sure what "my only tool" is but I am not a carpenter, so a
hammer is highly unlikely.😁

On Sat, Aug 21, 2021 at 1:57 PM <dw-murphy at cox.net> wrote:

> If the only tool you have is a hammer, you will start treating all your
> problems like a nail.
>
> Would be much easier to just query the web database from Access and do the
> required processing.
>
> Doug
> -----Original Message-----
> From: AccessD <accessd-bounces+dw-murphy=cox.net at databaseadvisors.com> On
> Behalf Of Jim Dettman via AccessD
> Sent: Saturday, August 21, 2021 5:43 AM
> To: 'Access Developers discussion and problem solving'
> <accessd at databaseadvisors.com>
> Cc: Jim Dettman <jimdettman at verizon.net>
> Subject: Re: [AccessD] Automating Outlook from Access
>
>
>  Actually, sounds like the long way around; the web site doesn't offer an
> API?
>
>  Scraping info from e-mails can be problematic, especially if you are not
> in
> control of the message format.
>
> Jim.
>
> -----Original Message-----
> From: AccessD On Behalf Of John Colby
> Sent: Saturday, August 21, 2021 8:21 AM
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> Subject: [AccessD] Automating Outlook from Access
>
> I am working on an app to process orders for a program.  A web site takes
> an
> order, accepts payment, then sends an email containing the order info.
> I need to receive the email, put email info into an email table, parse the
> order info out of the email body, put the order into an Order table, pull
> client info out of the order, place the client info into a client table,
> then go back and tie the email and order to the client via a client id.
>
> All of the outlook automation I learned from my best friend Google.  I'll
> write up how I am doing this stuff for anyone interested. I am not an
> expert
> and so any suggestions for how to do it better is good.  I will write a
> handful of emails to detail the parts and pieces.  This is actual code I am
> using
>
> In order to automate Outlook I need to sink Outlook events as email comes
> in
> which requires a class.  I create a plain old module to hold pointers to
> the
> Outlook class:
>
> Option Compare Database
> Option Explicit
>
> Private mclsOutlook As clsOfficeOutlook
>
> Function cOl() As clsOfficeOutlook
>     If mclsOutlook Is Nothing Then
>         Set mclsOutlook = New clsOfficeOutlook
>     End If
>     Set cOl = mclsOutlook
> End Function
>
> Function cOlTerm()
>     Set mclsOutlook = Nothing
> End Function
>
> --
> John W. Colby
> Colby Consulting
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
John W. Colby
Colby Consulting