[AccessD] Automating Outlook from Access

Sat Aug 21 20:09:16 CDT 2021

Interesting Stuart.  All I do is grab the main properties, from, to, time
and date, subject and body.  Where would I see the binary garbage.

As for polling, it seems so 1990s

On Sat, Aug 21, 2021 at 8:34 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> I've written a few similar applications over the years, but never used
> Outlook as an
> intermediary.  It munges emails when it receives them and puts all sorts
> of binary garbage
> in  with the actual message.
>
> It' s pretty easy to poll a POP3 mailbox directly, download the actual
> message and  parse
> the contents, especially if you control the way the email is generated.
>
> --
> Stuart
>
>
> On 21 Aug 2021 at 19:37, John Colby wrote:
>
> > 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
> > --
> > 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