| 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.
|
