[AccessD] Outlook Automation

[Bill Benson]

You can use olMailItem… just look up its integer equivalent in the
immediate window in Outlook VBE. If you like the intrinsic constant’s name
you can even declare it in the Access VBA
    PRIVATE CONST olMailItem as Integer = <value>


On Sat, Mar 23, 2024 at 9:59 AM Rocky Smolin <rockysmolin2 at gmail.com> wrote:

> Only sending.
>
> r
>
> On Sat, Mar 23, 2024 at 6:57 AM John Colby <jwcolby at gmail.com> wrote:
>
> > So you are not trying to watch mail received events?  You are only
> sending
> > email?
> >
> > On Sat, Mar 23, 2024 at 9:51 AM Rocky Smolin <rockysmolin2 at gmail.com>
> > wrote:
> >
> > > This is for one client. And they have Outlook. If I use early and one
> > user
> > > doesn't have it, the app will crap out with a broken reference and
> > they'll
> > > have to add Outlook to that user. Client is OK with that.
> > >
> > > But actually, I found out that the whole early/late thing was not a
> > > solution. It seems that the first test I did, the user had an email
> > address
> > > that just wouldn't compute - barfed on the ".To = " statement. Tried a
> > > different record and it worked.
> > >
> > > So now I've got to set up another 1/2 dozen or so test records and see
> if
> > > this was a one-off or some other problem.
> > >
> > > Bottom line - late binding works fine. So far. (Gotta love access...)
> > >
> > > tks
> > >
> > > r
> > >
> > > On Fri, Mar 22, 2024 at 8:46 PM John Colby <jwcolby at gmail.com> wrote:
> > >
> > > > I suggest that you do both early and late binding.  Use a global
> > compiler
> > > > constant to switch it.  In your code, bracket the early and late code
> > > > segments with #if statements.  Use early to figure it out then go to
> > late
> > > > for production.  AFAIK you can do anything in late that you can do in
> > > > early, you just have to know the syntax to get to the properties of
> > > things
> > > > as well as what things are called.  Any object in the library can be
> > > pulled
> > > > as object.
> > > >
> > > > The problem is that you simply cannot do "Dim X withevents" in late
> > > > binding.  The compiler can't figure out the events that an object is
> > > going
> > > > to have.  So automation isn't possible in late binding.  For this dev
> > > > environment I suggest getting a copy of Office 2013 and dev in that
> and
> > > > reference that.
> > > >
> > > > On Thu, Mar 21, 2024 at 6:59 PM Rocky Smolin <rockysmolin2 at gmail.com
> >
> > > > wrote:
> > > >
> > > > > Dear List:
> > > > >
> > > > > I am trying to create an email through Automation using late
> binding
> > > (in
> > > > > case the target machine does not have access loaded; I check for
> that
> > > > first
> > > > > and bail if no outlook).
> > > > >
> > > > > My DIMs:
> > > > >
> > > > > Dim myolApp As Object
> > > > > Dim myItem As Object
> > > > >
> > > > > Code:
> > > > > myItem.To = Me.fldTenantEmail
> > > > > myItem.cc = "Kathy.Klein at arensgroup.com"
> > > > > myItem.Subject = "Rent Increase Notice - " & Me.fldTenantCompany &
> "
> > -
> > > "
> > > > &
> > > > > me.fldTenantAddress & ", " & Me.fldTenantSuiteNumber
> > > > >
> > > > > The lines for .Subject and .CC work but Myitem.To fails with Method
> > > 'To'
> > > > of
> > > > > object '_MailItem' failed.
> > > > >
> > > > > Me.fldTenantEmail contains Armando at fallbrookirrigation.com
> > > > >
> > > > > If I substitute xx for Armando at fallbrookirrigation.com then it
> > works.
> > > > I'm
> > > > > thinking it may have something to do with the special characters?
> > > > >
> > > > > But I have cribbed this code from another app that works.
> > > > >
> > > > > Any ideas?
> > > > >
> > > > > MTIA
> > > > >
> > > > > Rocky
> > > > > --
> > > > > 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
> > --
> > 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
>