ALBERTO THAT’S IT!!
It works. I just modified the line to this:
Dim f As Xojo.io.folderitem = SpecialFolder.Documents.Child("Roster.sqlite")
Mailcomposeview.addAttachment(f, "application/x-sqlite3", f.name)
Thank you SO VERY MUCH Alberto, Jason T, and Jason K for all your help. And thank you Jason King for all your work on iOSKit. Its really great and a big help. I really appreciate you all taking the time to help.
Is there anyway to get this to send the email without prompting a user?
To send an email without prompting the user, you will certainly need to use an online API.
This might help: https://documentation.onesignal.com/docs/email-quickstart#section-email-service-provider-support
Apple deliberately prevents you from sending email without the user knowing to prevent an app from sending spam from their email without their knowledge. So you will need to use a service like Jeremie suggests.
I have a Mandrill iOS implementation in my apps. If you are interested in using it please PM me.
Mandrill is quite expensive for the low usage I have of it, OneSignal might be cheaper.
Does it allow attachment of a file?
Yes it does
Just discovered that SendGrid has a free plan (100 emails/day), I’ll be moving to SendGrid very soon