Home     Products      Support      Corporate     Sign In 
Support Knowledge Base, Article 245
Product
SMTPmail
Version
2.0 and 2.1
Title
MassMail method reports success but no emails are sent
Problem
If the MassMail method reports a successful send, but no emails are actually sent, there may be a case sensitivity issue between your recordset field names, and the string inside the %% delimiters.

If the string inside the %% delimeters corresponds to a recordset field name, MassMail will replace the %% delimiters, and the string inside the delimiters, with a new value. If a corresponding field name is not found, MassMail will not fail, it will simply treat the delimeters and everything inside them as a string. MassMail checks for corresponding field names in a case-sensitive manner.

Let's say, for example, your SQL statement looks like this:

SELECT Name, Email FROM Employees

and your SMTPmail code looks like this:

<% Mailer.AddRecipient "%%name%%", "%%email%%" %>

The MassMail method looks for columns called "name" and "email", all lower case. It does not find them, so instead of replacing the values and sending the emails, it treats "%%name%%" and "%%email%%" as strings.

Solution
When using the MassMail method, make sure that cases in your recordset field names and the string inside the %% delimiters are consistent.
Created : 12/1/2002 12:00:00 AM (last modified : 2/8/2002 3:11:00 PM)
Rate this article!
 
Comments