So I just learned that my employer blocks the .Send functionality of any attempt at sending a VBA email, but I know our SharePoint can send email ...

[diamondDog]

I am a total noob, but I've got big ideas!

Would it be possible to have VBA send mock records to a SharePoint list that sends the email that I need for those records? Haha. Like, the SharePoint list would only be there and require one or two columns worth of record data--just enough to trigger automatic emails that I would like to be sent to notify certain people that action is required on their part.

Just wondering if this kind of VBA is possible and what that code might look like. I am beyond annoyed that I cannot have my database platform notify folks of things and I am determined!

I was going to see if I could connect to a website mail server, but my employer blocks outlook.com and googlemail.com.

Any insight would be greatly appreciated!

 

[GPGeorge]

SharePoint supports Flows, which is also referred to as Power Automate. Look into creating a Flow that sends emails. I think you could link a SharePoint list into your Access FE accdb and append records to it for the email notifications and have that automatically trigger the email flow. I know only enough to suggest this as a line of inquiry into the possibility. I'd not suggest it, in any event, except that it appears to be the main path open to you in that environment.

 

[isladogs]

You could try using CDO to send email directly from Access without involving any external email app such as Outlook
Not sure I understand your comments about Sharepoint.

CDO EMail Tester

Used to test sending HTML or plain text emails directly from Access without using Outlook. Attachments can also be added. Attachments can also be added. EMail settings can optionally be included in the email body.

www.isladogs.co.uk

 

[theDBguy]

Hello. I support both comments. You don't need to use Outlook to send out emails, as long as you know the mail server settings, so you should probably try Colin's suggestion first. Then, if that doesn't work, you could try George's idea. Good luck!

 

[The_Doc_Man]

It is possible for various advanced firewalls and intelligent switches to block a specific protocol from a specific source. Do you know if your employer is blocking e-mails generally or is it specific to your VBA code? I had that problem with using CDO from Access. The way those end-to-end protocols work is that they include the name of the sending program. "SMTP from MSACCESS.EXE" was not on the "allowed" list. If your boss wants the e-mails because they have a legit business purpose, you can make it HIS/HER problem by saying "Please add an ALLOW option for SMTP from Access if you want the message to be sent." Then it isn't YOUR problem, it's the BOSS'S problem

 

[Bennet]

Ghetto solution: I often have Access write and execute autohotkey scripts. They might not let you automate email sending, but they probably can't stop you scripting the keystrokes that will generate and send one for you