Email sent to wrong recipients when using <ask> query in Online Express

When using Online Express to send out mass e-mails, you base this on a query. If you use a query that contains an <ask> operator then you are not prompted for this criteria in Online Express. This causes the wrong recipients to be added to the email list.

For example, query of e-mail number not blank may result in 30,000 constituents.
If <ask> query criteria is then added, this number may be reduced to 1,500 in the query results.
If this query is then used in Email Marketing then the e-mail is sent to 30,000 rather than 1,500 as <ask> query does not prompt for parameters.
 
Specify all criteria in the query rather than using <ask> operator.

Steps to Duplicate

 
  1. Create a constituent query using <ask> operator - eg Addresses > Preferred Address> Preferred City <ask>
  2. Save the query and Create new email in Online Express > EMail Marketing
  3. Complete the Design an click on Create new list on the Get ready to send tab.  Select the <ask> query and the number of e-mail addresses does not match the number of records in the query results.
  4. Occurs because when the query is selected, not prompted to supply the <ask> parameter so that criteria is ignored.

Environment

 Internet Explorer
 version 11
 Windows 7 (64-bit)
 SQL Server 2008 R2 Express
 Blackbaud Online Express

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.