[Solved] Visual basic for excel or VBA

Using Excel.UserRange, loop through the rows and access the cells by ThisWorkBook.Sheets(1).Cells(row, col).Value. If you find the value to be null or nothing or empty string, then call your sending mail function