[AccessD] Outlook Question

[Rocky Smolin]

Actually I added a third line to my create an item code:

    Set myolApp = CreateObject("Outlook.Application")
    Set myItem = myolApp.CreateItem(0)
    myItem.Display

So the email displays blank, then gets filled in as the code executes.

At the end of the email create:

    Set myolApp = Nothing
    Set myItem = Nothing

So Outlook goes away.

What could go wrong? :o)

r

On Mon, Jan 3, 2022 at 3:42 PM James Button via AccessD <
accessd at databaseadvisors.com> wrote:

> Or maybe permissions for one app to initiate another
>
> I have a similar setup for security in that I have set
> (so long ago I forget how)
> that one app selection of a link in an email, is not allowed to have the OS
> initiate a browser app.
> To process such things as a link wanting to use a browser there needs to
> be an
> existing EDGE session,
> however a doubleclick on a web link shortcut is allowed to initiate the
> EDGE
> browser.
>
> JimB
>
>
> -----Original Message-----
> From: AccessD
> <accessd-bounces+jamesbutton=blueyonder.co.uk at databaseadvisors.com> On
> Behalf Of
> Rocky Smolin
> Sent: Monday, January 3, 2022 11:20 PM
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] Outlook Question
>
> I found that the program runs perfectly if outlook is open and fails if it
> is not open.
>
> Could this have something to do with late binding?
>
> r
>
>
> On Mon, Jan 3, 2022 at 3:05 PM Susan Harkins <ssharkins at gmail.com> wrote:
>
> > But did that fix your error?
> >
> > Susan h.
> >
> >
> > Well, that was too easy. Outlook opens up now with the email set to send.
> > Which I don't have to do.
> >
> > Thanks so much.
> >
> > Rocky
> >
> > On Mon, Jan 3, 2022 at 1:03 PM Stuart McLachlan <stuart at lexacorp.com.pg>
> > wrote:
> >
> > > Go to Control Panel - Mail and remove any existing Data files and
> > Profiles.
> > >
> > > Then open Outlook and set it up from scratch.
> > >
> > >
> > >
> > > On 3 Jan 2022 at 11:31, Rocky Smolin wrote:
> > >
> > > > Doug:
> > > >
> > > > Unfortunately it won;t let me get past that prompt for the exchange
> > > > server address.
> > > >
> > > > r
> > > >
> > > > On Mon, Jan 3, 2022 at 10:55 AM <dw-murphy at cox.net> wrote:
> > > >
> > > > > In Outlook go to Account Settings and delete the Exchange account
> > > > > and add Gmail account.
> > > > >
> > > > > Doug
> > > > >
> > > > > -----Original Message-----
> > > > > From: AccessD
> > > > > <accessd-bounces+dw-murphy=cox.net at databaseadvisors.com> On Behalf
> > > > > Of Rocky Smolin Sent: Monday, January 3, 2022 10:36 AM To: Access
> > > > > Developers discussion and problem solving
> > > > > <accessd at databaseadvisors.com> Subject: [AccessD] Outlook Question
> > > > >
> > > > > Last year I abandoned Outlook along with my Beach Access Software
> > > > > website and domain and went to Gmail (resistance was futile. I was
> > > > > assimilated.)
> > > > >
> > > > > I got used to it so no worries there.
> > > > >
> > > > > Now I have a requirement from a client to create an email in
> > > > > Outlook from data in their database.  No problem.  Been there. Done
> > that.
> > > > > The common parts of the automation code is copy and paste.
> > > > > However...
> > > > >
> > > > > When I run the program, I get an automation error - library not
> > > > > registered. I do have Outlook installed and I did add the Outlook
> > > > > 14 library to the references. But that's not the problem
> > > > > apparently. I tried re-registering the library using guidance from
> > > > > Google but the regsrvr says library not found - even though it is
> > > > > there in the right folder.
> > > > >
> > > > > It *might* have something to do with the fact that Outlook was
> > > > > last configured to use GoDaddy's server. So when I start Outlook I
> > > > > get a message that the connection to Microsoft Exchange is
> > unavailable.
> > > > > Outlook must be connected to complete this action.
> > > > >
> > > > > Then opens a dialog box prompting for Exchange Server (showing the
> > > > > previous now non-functional server address) and Mailbox.
> > > > >
> > > > > I suspect that the Library Not Registered thing is a consequence
> > > > > of being hooked to an exchange server that is no longer there for
> me.
> > > > > But still I can't figure out how to tell Outlook this and then
> > > > > configure Outlook for Gmail so I can test this client's email
> > > > > automation thing I just wrote.  I don't need to send the email,
> > > > > just pop it up in Outlook so I can see that the formatting and
> > > > > data fields are all correct.
> > > > >
> > > > > Would uninstalling and reinstalling Office 2010 do this?  Or
> > > > > what's the shortest way to get where I'm trying to go here?
> > > > >
> > > > > MMMTIA
> > > > >
> > > > > Rocky
> > > > > --
> > > > > 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
>