Access When emailing brings up Outlook 2016 wizard to add email account

[turniporange23]

I am running Windows pro 11 and Microsoft access 2024 on a 64 bit operating systerm. When I uprgraded from Access 2013 to access 2024 , when My database activates to email its brings up Outlook 2016 wizard. I have Outlook new open but access dosent seem to want to use it.
Do you think it might have something to do with this psrt of the email code:

Dim myOut As Object, myItem As Object

Set myOut = CreateObject("Outlook.Application")

Set myItem = myOut.CreateItem(0)

I looked in my References and do have

Microsoft Access 16.0 Object Libary
Microsoft office 16.0 Access database engine Object

both ticked I could not find a Office 24 in the list

Thanks for any help..................Bob

 

[June7]

AFAIK, New Outlook cannot be automated. Is New Outlook your default email?

I don't use New Outlook at all.

 

[turniporange23]

AFAIK, New Outlook cannot be automated. Is New Outlook your default email?

I don't use New Outlook at all.

Yes and I dont like it I would to like to use another version can I change my email client?
Thanks Bob

 

[The_Doc_Man]

Changing to "Traditional" Outlook depends on what you had as an installation kit. However, the diagnosis of "New Outlook can't be automated" matches what I've read about it in many online articles. If you downloaded your Office from Microsoft, they might not have Traditional Outlook in that kit. If you had a third-party commercially available kit, perhaps of the LTSC style (Long Term Service Channel), you could get it to install the Traditional version. The problem is that Office has become insidious and will try to switch you to New Outlook surreptitiously.

 

[June7]

I upgraded from 2010 to 2021 last year. I bought Office 2021 Pro Plus from a 3rd party for $20. I don't quite remember how the install went with regard to Outlook but afterward I apparently had option to run New Outlook or revert to Old Outlook. Both show as available apps. My existing code for automating Outlook works.

However, I just checked what is set as my default email app and it shows Outlook (new). Changed to Old. Again, my code worked regardless.

 

[CJ_London]

Old outlook is now called classic outlook. In the search bar on the taskbar type ‘classic outlook’. Huge number of links out there for how to make classic the default app

 

[GPGeorge]

"New" Outlook does not support COM, i.e. the inter-application automation framework needed to automate it from other Office applications. Hence, the warning that you can't automate Outlook, using VBA, from Access.

It is written, I understand to use JavaScript instead. Microsoft has not yet taken any steps to address the problems this will cause for any existing Access database application that implements Outlook automation.

There are alternatives to Outlook. It's probably a very good idea to familiarize ourselves with those alternatives sooner, rather than latter. In the meantime, you can take steps to defer the migration to "Now" Outlook, as others have said.

 

[CJ_London]

the problems this will cause for any existing Access database application that implements Outlook automation.

Not just Access - also those who use macros in Excel and Word have the same problem

 

[GPGeorge]

Not just Access - also those who use macros in Excel and Word have the same problem

True. I was too parochial in my statement. My excuse is that I almost never use Excel or Word these days.

 

[turniporange23]

Thanks Guys Changed to outlook classic and my access database is now emailing, Had some trouble entering my details but finnaly figured out its not a POP account but a IMAP, Thanks again

 

[The_Doc_Man]

Ah, yes, the IMAP issue. Fortunately, Outlook handles several protocols, so that worked. In my case, I have POP for incoming and SMTP for outgoing mail.