What to do if a program is trying to access your e-mail?

A program is trying to perform an action that may result in an e-mail message being sent on your behalf. If this is unexpected, click Deny and verify your antivirus software is up-to-date.

How to send email based on access filter?

Send Email based on Data Filter¶. Because above VBA codes use current Access Data Connection and Recordset, so you can send email to specified recipients based on Access Filter. Go to Menu -> Home -> Filter Tab -> Advanced -> Advanced Filter/Sort. Field -> Department. Criteria -> IT. Close Filter Settings.

How to send email from MS Access using VBA?

Right click Users_Form -> Design View, Add two buttons by Design -> Select Button control: When you put the button on the form, it will popup a dialog box, simply click Cancel, then right click the button -> properties , set first button name to btnSend and Caption to Send Mail,…

Can you send email to only person in IT department?

Because above VBA codes use current Access Data Connection and Recordset, so you can send email to specified recipients based on Access Filter. You can see the form only displays the persons in IT department. If you click Send Email, only person in IT department will receive the email.

What to do if program is trying to access e-mail address?

A program is trying to access e-mail address information stored in Outlook. If this is unexpected, click Deny and verify your antivirus software is up-to-date. For more information about e-mail safety and how you might be able to avoid getting this warning, click Help.

How to send e-mail from MS Access using Outlook?

IO commented out the Excel code. Just put the results of your query into a string with each email address seperated with commas. To use your query’s values as recipients you should open a recordset from it [Query] and add recepients looping through the recordset. See the Microsoft Access Email FAQ – Outlook page at my website.