Android Question Send mail database

????

Tata Mapassa said:

Hello,
how to send an email to all email addresses in the Mail field of the T_contact table.
Thank

Click to expand...

Do you mean the smtp.to.addall(mailaddresslist)?

Yes, create a list with all the email addresses from the Mail field of the T_contact table. Thank you

You need to read the database using SQL then add the item into a list.

below is the code I use to retrieve the emails but using the list as the recipient of the email crashes

Dim ListMail As List
ListMail.Initialize
Dim Cursor As Cursor
Cursor = SQL1.ExecQuery("SELECT Mail FROM Table")
For i = 0 To Cursor.RowCount - 1
Cursor.Position = i
ListMail.Add(Cursor.GetString("Mail"))
Next
Cursor.Close
SQL1.Close

Try
Dim email As Email
email.To.AddAll(Array As String(ListMail))
email.Subject = ""
email.body =""
Dim in As Intent = email.GetIntent
in.Flags = 1 'FLAG_GRANT_READ_URI_PERMISSION
StartActivity(in)
Catch
Log(LastException)
End Try

Please use [code]code here...[/code] tags when posting code.