Filter out people who received a specific mailing

The request was made to be able to filter out people who received a specific mailing. The views_mail_scheduled log table contains the e-mails sent, but I have so far been unable to figure out a way to link those e-mail addresses to the source e-mail addresses in the source node (the node you used in your view to create the mailing list in the first place)

So, I figured the best way to handle this was to add another field to the views_mail_scheduled table: recipient_nid. This is the node id of the node from which the recipient_email is derived (if, in fact, it is taken from a node).

So, if you wish to create a view that contains both the source node for your e-mails, and the views_mail_scheduled log of e-mails sent, then you will need to:

a. Include a "node id" field in your view. This will be the node id of the record which contains the e-mail you are selecting for the view.

b. Select this node id field when you "Configure" your Views Mail mailing.

When you do the above, the node id for each e-mail address will be recorded into the views_mail_scheduled log table when the mailing is processed. This will allow you to create a view that can be "filtered" by both the views_mail and views_mail_scheduled log fields.

If your e-mail addresses are not coming from a node, then select "none" for the "node id" field in the "Configure mailing" step.

The code changes for this update will be submitted to CVS shortly, and available for download in the dev release. Please note that you when you install this latest update, you will also need to run "update.php" as the views_mail_scheduled table has been modified.