Home     Products      Support      Corporate     Sign In 
Support Knowledge Base, Article 245
2.0 and 2.1
MassMail method reports success but no emails are sent
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.

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!