Add Bcc addresses from a column of a datagridview

Question

I'm creating a program that reads a column of a datagridview that contains email addresses and inserts them as Bcc.

I would like to write multiple email addresses in the Bcc.

I can enter one email address.

Mail.Bcc.Add(New MailAddress(Form10.DataGridView1.Rows(3). Cells(4). Value))

I would like to take all the column 4 of my datagridview.

score 0 · Answer 1 · answered Nov 17 '22 at 12:29

Assuming you mean that you have multiple email addresses in the cell, presumably separated by some form of delimiter, then you can achieve what you want with code similar to this:

Dim MyEmailAddresses() As String, EmailAddress As String

MyEmailAddresses = Split(Form10.DataGridView1.Rows(3).Cells(4).Value, ",")

For Each EmailAddress In MyEmailAddresses
    Mail.Bcc.Add(New MailAddress(EmailAddress)
Next EmailAddress

In this case, I have assumed that your email addresses are comma separated. If you use a different delimiter, simply replace "," with whatever delimiter you are using.

Add Bcc addresses from a column of a datagridview

1 Answers1