Urgent Help Needed!! Table creation in lotus notes mail through VBA

[Krithi]

Hello All,

I am in an urgent need of a macro that would create a table and send the same though lotus notes mail.

My requirement is:

1. Any cell in a row ranging A3:XFD3 would contain today's date. I need to compare today's date with the cell dates and should find out the cell which contains today's date. - This part is done and is working fine.

2. Identify the column and Pick up the blank cells in this column (assume column C) - This part is also done

3. Pick up the names present in a different column (assume column A) and the IDs present in another column (assume column H) and paste it in a table format with 2 columns and the N rows (N represents the number of blank cells in column C) and send this data as Rich text through lotus notes. - Am struggling to get this part.

Sample Table data:

S.No	ID	Name
1	4566	TEST
2	6598	TEST2
3	6597	TEST3
4	9758	TEST4

<tbody>
</tbody>

Your help would be highly appreciated. I searched through N number of threads but couldn't find any matching my requirement. This is an urgent requirement. Please help!!

Regards
Krithi