Skip to main content

BPA: Fix a BPA alert that isn't sending emails to all recipients in Access APS

Steps to stop a BPA alert from stopping when a recipient has no email address, and to make it use the correct query step.

A BPA alert can stop part-way through sending emails, or leave out recipients who should receive one, when two settings are wrong. Follow these steps to fix both.


Why this happens

The alert is designed to send an email to anyone with an email address in Email_General. Two issues stopped it from doing this. The second is the main cause.

  • The database query returned three clients with a birthday on that date, but only one of them had an email address in Email_General. The Send Message (SMTP) step's If an error occurs: setting was Abort Stop, so the step stopped when it reached a client with no email address.

  • The Format As HTML step was receiving its data from a query step that wasn't in the alert's Design pane.

📌Note: Only steps in the Design pane are scripted into the alert.

⚠️Important: Deleting a step from the Design pane doesn't delete it from the alert. To delete a step from the alert, go to the Environment tab at the Task scope, right-click the step, then select Delete Step.


Resolve the issue

Make both changes to the alert.

  1. Set If an error occurs: to Continue in the Options tab of the Send Message (SMTP) step.

  2. In the Format As HTML step, on the General tab, change Input Recordset to Database Query (ODBC) 1.

With the Continue setting, the step carries on sending emails when it reaches a recipient with no email address. After you complete both steps, the task sends emails to every recipient who has an email address.


​

Did this answer your question?