Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Built-in Functions _ Mystery Email Button

Posted by: Wedge Aug 24 2018, 05:35 PM

Okay - this is a weird one. I have an install of Access where the email button in report print preview stays greyed out so I cannot email any reports or anything for that matter. It doesn't matter if I use VBA with SendObject either - it still just gives a 2046 error. Works perfectly on lots of other systems. Thinking something strange I wiped the machine and started again with the same problem. Latest version of Windows 10 Pro and Access 2016. See screenshot. Hoping someone has a few ideas as to why the email system doesn't seem to initialise. I have tried 'repair Access' to no avail. Windows 10 mail works fine and Excel 2016 also works with emailing - it just seems to be Access. It's like there is some permission issue - but I have never seen this before. ???


Posted by: theDBguy Aug 24 2018, 05:53 PM

Hi,

It may be related to a recent bug with the SendObject method. Outlook automation or using CDO should still work.

Just my 2 cents...

Posted by: Wedge Aug 25 2018, 11:24 AM

Yes - it could be but this works fine on other installs. Unless the bug is specific to certain configurations? I wish MS would just get to fixing it then we could rule it out. Until then it is very strange. Can you use Outlook automation with a different email client though?

Posted by: theDBguy Aug 25 2018, 11:34 AM

Hi Sam,

No, you can automate Outlook only if it is installed. But, you can use CDO regardless of email clients.

Posted by: Wedge Aug 27 2018, 03:06 PM

Okay - so I now have an understanding. It only works if Outlook or Windows Live Mail is installed. If I install either of these apps and then change the default app to a different mail client - it works. It's as if you need to install an MS client first and then you are okay. If I take Outlook or Live mail off it stops working. This is on a clean wiped - 'fresh start' latest Windows 10 install. The Mail client that comes with Windows 10 has no effect - I have to install Outlook and then the Email icon is enabled. What is also strange is that it seems to ignore the default email app setting in Windows 10 - I have to change the default text in the registry.

To be honest I have only used Live Mail or Outlook in the past so only noticed this when I setup a completely clean Windows 10 pro machine.

Weird.

Posted by: theDBguy Aug 27 2018, 03:12 PM

Hi Sam,

If it's related to the recent bug in Office/Windows, it might get fixed later on. Then, you won't have this weird behavior anymore.

Cheers!

Posted by: Wedge Sep 5 2018, 11:26 AM

Fingers crossed! Again! smile.gif

Posted by: Gansmann Aug 14 2019, 07:36 AM

Ok, I can report that as of Aug 2019 the problem still exists. I recently got a new computer at work and we switched from Win 7 to 10. For our office suite we use MS Office 365 and Outlook as an email client. But, because Office 365 does not offer Access that was installed off of Office 2013 by itself.
Now you know what I'm working with, here's what I'm seeing. When I open any database directly the email button is greyed out in "External Data/Export" and report "Print Preview". When I open Access first then select a database from "Recent" or "Open Other Files" the email button works normally. So, I figured once I have the email button active I'll create a "Saved Export." It turns out to be greyed out on some of my databases.
Guess I'll be pinning a lot of databases to my Access button on the taskbar. Frustrating!