Goldmine email blast -- need to find out who didn't get the email

[ttrsux]

Hello,

Recently we did an email blast to two different databases. We did an email blast to basically everyone in our database who had an email address in the "email address field". Well, at 5 p.m. I started the blast, and the next day around 8 a.m. when I came in, I found Goldming stopped and it said "some of the recipients could not be sent to..." and "to see the specific error messages, send the email to each individual...". Well, basically, I need to find out who didn't get this email.

The email's subject began with "Announcement and CFP:", so I made a SQL query as such:

SELECT accountno, contact from CONTACT1 where accountno not in (SELECT accountno from CONTHIST where ref NOT LIKE 'Announcement and CFP:%')

I don't think this worked however. If anyone knows a SQL query that would find all contacts who didn't receive an email with the subject of "announcement and cfp:%", please let me know. I greatly appreciate it.

djb

 

[richardy]

Hi,

The problem is that you have a not not in there, one not is enough not to nots as that inverses the first not making it redundant.

So not to put to finer a point on it I think you need some like this:


SELECT accountno, contact from CONTACT1 where accountno not in (SELECT accountno from CONTHIST where ref LIKE 'Announcement and CFP:%')

If this is not the case then I'll need to check closer

Regards,

Richard.
PRIOR Analytics UK

http://www.prior-analytics.com

Regards,

Richard.
PRIOR Analytics UK

http://www.prior-analytics.com

Winners of the LBA Customer Service Award.

 

[ttrsux]

It's too bad the preview window only shows 10,000 records. I called Goldmine and they verified it (at least the person I talked to did). Thanks for the feedback ; that first sentence put my brain to work for a minute. I think that worked by the way, but my computer takes about 5 minutes to finish the query every time. Is there a way to directly output to a file (so it outputs ALL the output instead of just 10,000?), and that way I can import to a new database and send to all in that database. If GM could display all the records vs. only 10,000, I could just create a filter from the group created by the query, but since only 10k are returned, I think the only option is to output and import... etc. If you have any ideas please feel free to share. Thanks.

Dan B.