[AccessD] Automating Outlook

Rocky Smolin rockysmolin2 at gmail.com
Tue Aug 24 07:31:03 CDT 2021

John, I've done a  bit of Outlook automation but always kept it very
simple. I'm on the road this week so I can't look at the properties and
methods etc., exposed in the Outlook Object. But a couple of questions to
start with - 1) What will trigger your program to process an incoming
email? 2) Is the email one generated by the web app or the email that the
user entered?

Your task, it seems to me, is to extract the info from the email to create
a purchase order in your database.- with the usual P.O. Header and P.O.
Detail fields.  Correct?


On Mon, Aug 23, 2021 at 10:26 PM John Colby <jwcolby at gmail.com> wrote:

> I really need to cut off all the "you oughta" stuff.  Look, I am a single
> access developer / consultant, who was called out of retirement to assist
> another single access developer / consultant who had developed an Access
> app.
> I work on a laptop.  I work on this project about 20 hours a week around my
> regular job.  My partner works on this project about the same, around
> providing for his family.  My partner is paying (out of his own pocket) for
> a web developer in India to design a web site to sell this app he
> developed.
> I work on my laptop.  Sometimes I work from my home office with a real
> internet.  The rest of the time I work on my laptop over a cell connection
> with anywhere from 5 bars to ZERO BARS connectivity.  Whatever development
> I do I have to do on a laptop, which may or may not even connect to the
> internet.
> So telling me I should " POST a Json notification to the API of a local
> webserver which then does the order processing in seconds" and the like is
> simply not helpful.
> I thought I'd discuss automating Outlook.  I thought that someone might be
> interested in that.  So far I'm pretty much just getting suggestions on
> what I should be doing from folks that don't have a clue what I am doing.
> And rather than discussing automating Outlook I am discussing everything
> but that.
> From my perspective, KISS.  An order comes in, send me a damned email.
> I'll take it from there.  I can connect whenever I can connect, collect the
> emails, and process them.  In the meantime I can do what I am doing
> completely off line.
> If anyone is interested in Access, classes and automating Outlook, I'm
> ready, willing and able to discuss that.  "Polling servers and JSON files"
> is not something that makes sense for me.
> Thanks for your understanding.
> --
> John W. Colby
> Colby Consulting
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

More information about the AccessD mailing list