How to avoid empty cell from Excel sheet

Hi i have a problem with excel sheet i have 5 columns and in that i have email addresses for to and cc so in that some are filled and some are empty so i am trying to send smtp mail but its giving me error like “Send SMTP Mail Message: The parameter ‘addresses’ cannot be an empty string. Parameter name: addresses” so i want condition so that if it is empty it will skip it and continue with next column.

Hi @amir.shiraz

Welcome to Community,

How are you passing the Excel Row data to SMTP, is it using for each loop, if so you can have a IF condition and check string. IsNullOrEmpty(dt.row(column1).toString)

Thanks

Hi @suraj.setty
Thanks for the solution
Really appreciate

Glad that helped,

Thanks

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.