APEX

Hello,

I have a small table (PK=record_id) from which I send mail to a user of informational reasons. At the moment I can only send all records in a mail, but I want to be more 'selective', send only marked records.
The table is shown in a APEX-report defined as an updateable report.
I added a column [record selector] to it, allowing me to put a mark before the record to be send.
I did not succeed however sending the user only the marked records....
I tried something like
...
BEGIN
-- Loop through the rows that have been checked.
FOR I IN 1..HTMLDB_APPLICATION.G_F01.COUNT
LOOP
SELECT record_id
INTO to_be_send_record
FROM meldingen_voor_postverzending
where HTMLDB_APPLICATION.G_F01(I) = 'Y' ;

-- place the record with record_id = to_be_send_record
-- into a mail (via a self-made package) ...
END LOOP;
-- send the mail (using HTMLDB_MAIL)
...
END ;

It looks as if the records marked are not selected, but I can't find the reasopn why.
Maybe the = 'Y' is not correct, but I also tried "is not null" , '!= NULL" and other things.

Can anybody help me getting opnly the checked records into the mail-body?

Thanks and regard,
Jan.