Alerts Issue

[hariprasadqv]

Hi All,

I Need to send an email automatically to the users who's DOB field is empty and I have to display the number of user without DOB and All of their Id.

Table;

UID        DOB               Email

01          01/03/1978       123@xxxxx.com

02                                 345@xxxxx.com

03          30/12/1965       125@xxxxx.com

04          29/06/1985        323@xxxxx.com

05                                  723@xxxxx.com

06                                  127@xxxxx.com

Alert would be like:

No of user without DOB: 3

UserId : 02,05,06