Foxtable(狐表)用户栏目专家坐堂 → 求助:如何实现根据多行选择,进行发送多封邮件!


  共有2479人关注过本帖树形打印复制链接

主题:求助:如何实现根据多行选择,进行发送多封邮件!

帅哥哟,离线,有人找我吗?
有点甜
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:版主 帖子:85326 积分:427815 威望:0 精华:5 注册:2012/10/18 22:13:00
  发帖心情 Post By:2019/2/12 15:35:00 [显示全部帖子]

1、


Dim tbl As Table = Tables("人员关联表")
For Each rw As Row In tbl.GetCheckedRows
    Dim ab As Row = Tables("系统信息").Current
    Dim drs = DataTables("告知内容").Select("姓名 = '" & rw("姓名") & "'And 是否告知 = '否' " )
    For Each dr As DataRow In drs
        Dim client As New System.Net.Mail.SmtpClient(ab("单位QQ邮件网关"), ab("单位QQ邮件端口")) '或者465
        client.EnableSsl = True 'SSL
        client.Credentials=New System.Net.NetworkCredential(ab("单位QQ邮件"), ab("单位QQ邮件发送授权码"))
        client.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network
        Dim message As New System.Net.Mail.MailMessage()
        message.From=new System.Net.Mail.MailAddress(ab("单位QQ邮件"), ab("单位QQ邮件别名"))
        message.To.Add(new System.Net.Mail.MailAddress(rw("电子邮件"), rw("姓名")))
        message.To.Add(rw("电子邮件"))
        message.Subject = "瓮安检察" & dr("流程名称") & "通知"
        message.BodyEncoding = System.Text.Encoding.UTF8
        Dim content As String
        content &= "【"& rw("姓名") & "】" & rw("称谓") & "您好!" & vbcrlf
        content &=  vbcrlf
        content &= dr("涉案人名") & "涉嫌" & dr("涉案罪名") & "一案,经我院" & dr("流程时间") & "审查,现在已经进入【" & dr("流程名称") & "】" & vbcrlf
        content &=  vbcrlf
        content &= dr("注意事项")
        message.Body = content
        Dim attachment As new  System.Net.Mail.Attachment("d:\test.xls",  System.Net.Mime.MediaTypeNames.Application.Octet)
        message.Attachments.Add(attachment)
        AddHandler client.SendCompleted, AddressOf SendCompletedCallback
        Dim userState As String = "test message1"
        client.SendAsync(message, userState)
        dr("是否告知")="是"
    Next
Next

 

2、你输入的发送的邮箱,必须正确。你【王五】的邮箱是错误的邮箱。


 回到顶部
帅哥哟,离线,有人找我吗?
有点甜
  2楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:版主 帖子:85326 积分:427815 威望:0 精华:5 注册:2012/10/18 22:13:00
  发帖心情 Post By:2019/2/12 15:54:00 [显示全部帖子]

用这种方式测试,看是否报错。

 

Dim client As New System.Net.Mail.SmtpClient()
'client.timeout = 1000 '1秒
client.Host = "smtp.qq.com"
client.Credentials = New System.Net.NetworkCredential("455189993@qq.com", "helen6849338.")
client.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network
Dim message As New System.Net.Mail.MailMessage
message.From = new System.Net.Mail.MailAddress("455189993@qq.com")
message.To.Add("765427475@qq.com")

'message.Bcc.Add("2450314695@qq.com") '密送

'message.cc.Add("2450314695@qq.com") '抄送

Dim content As String

content &= "这是文字" & vbcrlf
content &= "也是文字"

message.Body = content

Dim attachment As new  System.Net.Mail.Attachment("d:\test.xls",  System.Net.Mime.MediaTypeNames.Application.Octet)
message.Attachments.Add(attachment)

Try
    client.Send(message)
    msgbox("发送成功")
Catch ex As Exception
    msgbox("发送失败:" & ex.message)

finally

    message.Dispose()
End Try


 回到顶部
帅哥哟,离线,有人找我吗?
有点甜
  3楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:版主 帖子:85326 积分:427815 威望:0 精华:5 注册:2012/10/18 22:13:00
  发帖心情 Post By:2019/2/12 15:54:00 [显示全部帖子]

如果报错,说明QQ邮箱有限制,参考

 

https://jingyan.baidu.com/article/915fc414f7a3e151394b20bb.html

 


 回到顶部