Hi,

First time here. Looks quite nice. I have a little problem with something. I'm trying to send out e-mails using Persits Email Component. I have an access database with a row called (Email) and several emails inside of it (About 10 emails). How to i form my SQL Query and what should i do so that when i get to this

It send the email to everybody that had an email in that row. Thanks for any help provided, very much appreciated.

Depending on whether that email field is NULL or just empty (I can't remember if Access has NULL fields or not) then your SQL would look like:

(If using NULL for blank fields)
SELECT * FROM myTable WHERE Email != NULL

(If using empty fields)
SELECT * FROM myTable WHERE Email != ''

myTable is the name of the table with the Email field and '' are two 'single quotes'

If all you want is the email address in the recordset, replace "*" with "Email"

Yes, MS-Access does support NULLs. And I think you'll find that it won't accept != NULL.

I think you'll find it wants IS NOT NULL.

Because NULL denotes "the absence of a value" it plays by some special rules.

my bad... I stand corrected... haven't had to query for nulls (or lack thereof) in some time...

Thank you very much works like a charm !