Store the column value of datagridview in Array list

Question

I have a datagridview which is populated from Excel Sheet.

There a four columns in Datagrid view  Name ,Email ,Phone, Country

Now i want to store all the emails in a list/arraylist to send mail.

How can i do this?

Answer 1

You can get each email address string value using the DataGridView.Item property: http://msdn.microsoft.com/en-us/library/ms158655

And then you can send emails using the MailMessage class, you can use this forum: http://social.msdn.microsoft.com/Forums/en-US/ncl/threads 

and if you have any problem using Windows Form's DataGridView, you can use this forum: http://social.msdn.microsoft.com/Forums/en-US/winformsdatacontrols/threads 

And if you want automate the outlook to send the mail, then you can use this forum: http://social.msdn.microsoft.com/Forums/en-US/outlookdev/threads

 

---

Mike Zhang[MSFT]
MSDN Community Support | Feedback to us