VB.NET导出Outlook邮件,新建压缩文件并自动发送.

该代码示例展示了如何使用VB.net结合Outlook进行文件压缩、邮件发送以及创建包含HTML表格的邮件内容。首先,它创建一个ZIP文件并压缩指定文件夹,然后通过Outlook发送带有压缩文件附件的邮件,邮件内容包括格式化的HTML表格。接着,代码遍历文件夹,将特定类型的文件添加到新的ZIP文件中,再次发送邮件。邮件接收者、抄送者以及主题可以根据需求更改。
摘要由CSDN通过智能技术生成

VB.net 链接Outlook
添加引用:
Imports Microsoft.Office.Interop.Outlook
Imports Ionic.Zip
在这里插入图片描述
下面直接上代码,希望能帮到大家!
1、直接压缩文件夹

        '"versionFolder" 为存档的路径
        Dim versionFolder As String = "" & SubDir.FullName & "\07-Hot runner System drawing 3D"
        '"zipFile" 为新建的zipfile 压缩空文件,括号里是指定的路径(此处是将整个文件的数据全部压缩)
        Dim zipFile As New ZipFile("" & versionFolder & "\3D_CUTOUT." & jobName & "_" & myVersion & "_" & moulderNO & "_" & Format(Now.Date, "dd.MM.yyyy").ToString & ".zip", System.Text.Encoding.Default)
        '直接压缩整个文件夹  " & myVersion & "
        zipFile.AddDirectory("" & versionFolder & "\" & myVersion & "")
        '此处想做一个缓存,即Form3跳出窗口模式,开始读秒(共10秒)。
        'wait all the file into the zip file 
        Form3.Show()
        Timer2.Enabled = True
        Timer2.Interval = 1000
        Timer2.Start()
        
       'zipfile save 'ZipFile 保存
        zipFile.Save()
       '此处链接的是数据库,大家可以酌情处理
        If Not IsDBNull(DataGridView3.Rows(i4).Cells(9).Value) Then
            mySQ = DataGridView3.Rows(i4).Cells(9).Value.ToString.Substring(0, 13)
        End If
     
        ' send e-mail 
            item = outObj.CreateItem(0)
            item.To = "xx"  '此处需要输入收件人
            item.CC = "xxx" & ";" & "xxx" & ";" & "xxx" & ";" & "xxx" 
            item.Subject = "3D cutout data of project"  '输入主题   
             '此处是增加了两组表格(HTML),请注意下面所有的"xx"均需要酌情更改自己的内容        
            item.HTMLBody = "Hello Bill:<br/>Please fimd the 3d cutout data of project "xx" as attached.<br/>Please send it to customer for confirmation." &
                        "<table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0 style='border-collapse: collapse; border-bottom: medium none; border-left: medium none; mso-border-alt: solid windowtext .5pt; mso-yfti-tbllook: 1184;mso-padding-alt: 0in 5.4pt 0in 5.4pt'>" &
                      "<tr style='mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes'>" &
                   "<td style='border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; border-bottom: windowtext 1pt solid; padding-bottom: 0in; padding-top: 0in; padding-left: 5.4pt; border-left: windowtext 1pt solid; padding-right: 5.4pt; mso-border-alt: solid windowtext .5pt' valign='top' width='300'>" &
                 "<p Class='MsoNormal' style='margin: 0in 0in 0pt'><span lang='ZH-CN' style='font-family: ; mso-ascii-font-family: 微软雅黑; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 微软雅黑'><font face='宋体'>"xx"</font></span></p>" &
               "<td style='border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; border-bottom: windowtext 1pt solid; padding-bottom: 0in; padding-top: 0in; padding-left: 5.4pt; border-left: windowtext 1pt solid; padding-right: 5.4pt; mso-border-alt: solid windowtext .5pt' valign='top' width='300'>" &
             "<p Class='MsoNormal' style='margin: 0in 0in 0pt'><span lang='ZH-CN' style='font-family: ; mso-ascii-font-family: 微软雅黑; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 微软雅黑'><font face='宋体'>"xx"</font></span></p>" &
           "<td style='border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; border-bottom: windowtext 1pt solid; padding-bottom: 0in; padding-top: 0in; padding-left: 5.4pt; border-left: windowtext 1pt solid; padding-right: 5.4pt; mso-border-alt: solid windowtext .5pt' valign='top' width='300'>" &
         "<p Class='MsoNormal' style='margin: 0in 0in 0pt'><span lang='ZH-CN' style='font-family: ; mso-ascii-font-family: 微软雅黑; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 微软雅黑'><font face='宋体'>"xx"</font></span></p>" &
       "<td style='border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; border-bottom: windowtext 1pt solid; padding-bottom: 0in; padding-top: 0in; padding-left: 5.4pt; border-left: windowtext 1pt solid; padding-right: 5.4pt; mso-border-alt: solid windowtext .5pt' valign='top' width='300'>" &
     "<p Class='MsoNormal' style='margin: 0in 0in 0pt'><span lang='ZH-CN' style='font-family: ; mso-ascii-font-family: 微软雅黑; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 微软雅黑'><font face='宋体'>"xx"</font></span></p>" &
   "<td style='border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; border-bottom: windowtext 1pt solid; padding-bottom: 0in; padding-top: 0in; padding-left: 5.4pt; border-left: windowtext 1pt solid; padding-right: 5.4pt; mso-border-alt: solid windowtext .5pt' valign='top' width='300'>" &
  "<p Class='MsoNormal' style='margin: 0in 0in 0pt'><span lang='ZH-CN' style='font-family: ; mso-ascii-font-family: 微软雅黑; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 微软雅黑'><font face='宋体'>"xx"</font></span></p>" &
  "</td>" &
  "</tr>" &
  "<tr style='mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes'>" &
   "<td style='border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; border-bottom: windowtext 1pt solid; padding-bottom: 0in; padding-top: 0in; padding-left: 5.4pt; border-left: windowtext 1pt solid; padding-right: 5.4pt; mso-border-alt: solid windowtext .5pt' valign='top' width='300'>" &
    "<p Class='MsoNormal' style='margin: 0in 0in 0pt'><span lang='ZH-CN' style='font-family: ; mso-ascii-font-family: 微软雅黑; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 微软雅黑'><font face='宋体'>"xx"</font></span></p>" &
     "<td style='border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; border-bottom: windowtext 1pt solid; padding-bottom: 0in; padding-top: 0in; padding-left: 5.4pt; border-left: windowtext 1pt solid; padding-right: 5.4pt; mso-border-alt: solid windowtext .5pt' valign='top' width='300'>" &
      "<p Class='MsoNormal' style='margin: 0in 0in 0pt'><span lang='ZH-CN' style='font-family: ; mso-ascii-font-family: 微软雅黑; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 微软雅黑'><font face='宋体'>"xx"</font></span></p>" &
       "<td style='border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; border-bottom: windowtext 1pt solid; padding-bottom: 0in; padding-top: 0in; padding-left: 5.4pt; border-left: windowtext 1pt solid; padding-right: 5.4pt; mso-border-alt: solid windowtext .5pt' valign='top' width='300'>" &
        "<p Class='MsoNormal' style='margin: 0in 0in 0pt'><span lang='ZH-CN' style='font-family: ; mso-ascii-font-family: 微软雅黑; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 微软雅黑'><font face='宋体'>"xx"</font></span></p>" &
         "<td style='border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; border-bottom: windowtext 1pt solid; padding-bottom: 0in; padding-top: 0in; padding-left: 5.4pt; border-left: windowtext 1pt solid; padding-right: 5.4pt; mso-border-alt: solid windowtext .5pt' valign='top' width='300'>" &
          "<p Class='MsoNormal' style='margin: 0in 0in 0pt'><span lang='ZH-CN' style='font-family: ; mso-ascii-font-family: 微软雅黑; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 微软雅黑'><font face='宋体'>"xx"</font></span></p>" &
           "<td style='border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; border-bottom: windowtext 1pt solid; padding-bottom: 0in; padding-top: 0in; padding-left: 5.4pt; border-left: windowtext 1pt solid; padding-right: 5.4pt; mso-border-alt: solid windowtext .5pt' valign='top' width='300'>" &
            "<p Class='MsoNormal' style='margin: 0in 0in 0pt'><span lang='ZH-CN' style='font-family: ; mso-ascii-font-family: 微软雅黑; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 微软雅黑'><font face='宋体'>"xx"</font></span></p>" &
             "</td>" &
             "</tr>" &
             "</tbody></table>" &
             "<br/><br/>Thank you! <br/> Best Regards"
           '添加附件
            item.Attachments.Add("此处需要输入上面新建ZipFile 的路径")
           '删除上面创建的压缩包,因为如果不删除没办法再次新建。
            My.Computer.FileSystem.DeleteFile("此处需要输入上面新建ZipFile 的路径")
            '邮件显示,或直接发送
            item.Display()  
            'item.send()
      

2、添加指定的单独文件至压缩包中…

        Dim myManuDraw As String = "" & SubDir.FullName & "\08-Manufacturing Drawings"
        Dim zipFile As New ZipFile("" & myManuDraw & "\" & jobName & "-Manufacturing Drawings.zip", System.Text.Encoding.Default)
        '此处不一样,我做了遍历文件夹获得想要的文件的操作
        For Each SubSubDir As String In My.Computer.FileSystem.GetFiles(myManuDraw, FileIO.SearchOption.SearchAllSubDirectories, "*.*")
            If InStr(SubSubDir, "ASSY") = 0 And InStr(SubSubDir, "BOM") = 0 Then             
                '此处AddFile 格式一定是(文件的Path,""),不然会在压缩包里建立层层空的文件夹,请注意!
                zipFile.AddFile(SubSubDir, "")
            End If
        Next

        'wait all the file into the zip file 
        Form3.Show()
        Timer2.Enabled = True
        Timer2.Interval = 1000
        Timer2.Start()

        'zipfile save 
        zipFile.Save()

        If Not IsDBNull(DataGridView3.Rows(i4).Cells(9).Value) Then
            mySQ = DataGridView3.Rows(i4).Cells(9).Value.ToString.Substring(0, 13)
        End If

       item = outObj.CreateItem(0)
            item.To = "xx"  '此处需要输入收件人
            item.CC = "xxx" & ";" & "xxx" & ";" & "xxx" & ";" & "xxx" 
            item.Subject = "3D cutout data of project"  '输入主题   
             '此处是增加了两组表格(HTML),请注意下面所有的"xx"均需要酌情更改自己的内容        
            item.HTMLBody = "Hello Bill:<br/>Please fimd the 3d cutout data of project "xx" as attached.<br/>Please send it to customer for confirmation." &
                        "<table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0 style='border-collapse: collapse; border-bottom: medium none; border-left: medium none; mso-border-alt: solid windowtext .5pt; mso-yfti-tbllook: 1184;mso-padding-alt: 0in 5.4pt 0in 5.4pt'>" &
                      "<tr style='mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes'>" &
                   "<td style='border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; border-bottom: windowtext 1pt solid; padding-bottom: 0in; padding-top: 0in; padding-left: 5.4pt; border-left: windowtext 1pt solid; padding-right: 5.4pt; mso-border-alt: solid windowtext .5pt' valign='top' width='300'>" &
                 "<p Class='MsoNormal' style='margin: 0in 0in 0pt'><span lang='ZH-CN' style='font-family: ; mso-ascii-font-family: 微软雅黑; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 微软雅黑'><font face='宋体'>"xx"</font></span></p>" &
               "<td style='border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; border-bottom: windowtext 1pt solid; padding-bottom: 0in; padding-top: 0in; padding-left: 5.4pt; border-left: windowtext 1pt solid; padding-right: 5.4pt; mso-border-alt: solid windowtext .5pt' valign='top' width='300'>" &
             "<p Class='MsoNormal' style='margin: 0in 0in 0pt'><span lang='ZH-CN' style='font-family: ; mso-ascii-font-family: 微软雅黑; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 微软雅黑'><font face='宋体'>"xx"</font></span></p>" &
           "<td style='border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; border-bottom: windowtext 1pt solid; padding-bottom: 0in; padding-top: 0in; padding-left: 5.4pt; border-left: windowtext 1pt solid; padding-right: 5.4pt; mso-border-alt: solid windowtext .5pt' valign='top' width='300'>" &
         "<p Class='MsoNormal' style='margin: 0in 0in 0pt'><span lang='ZH-CN' style='font-family: ; mso-ascii-font-family: 微软雅黑; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 微软雅黑'><font face='宋体'>"xx"</font></span></p>" &
       "<td style='border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; border-bottom: windowtext 1pt solid; padding-bottom: 0in; padding-top: 0in; padding-left: 5.4pt; border-left: windowtext 1pt solid; padding-right: 5.4pt; mso-border-alt: solid windowtext .5pt' valign='top' width='300'>" &
     "<p Class='MsoNormal' style='margin: 0in 0in 0pt'><span lang='ZH-CN' style='font-family: ; mso-ascii-font-family: 微软雅黑; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 微软雅黑'><font face='宋体'>"xx"</font></span></p>" &
   "<td style='border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; border-bottom: windowtext 1pt solid; padding-bottom: 0in; padding-top: 0in; padding-left: 5.4pt; border-left: windowtext 1pt solid; padding-right: 5.4pt; mso-border-alt: solid windowtext .5pt' valign='top' width='300'>" &
  "<p Class='MsoNormal' style='margin: 0in 0in 0pt'><span lang='ZH-CN' style='font-family: ; mso-ascii-font-family: 微软雅黑; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 微软雅黑'><font face='宋体'>"xx"</font></span></p>" &
  "</td>" &
  "</tr>" &
  "<tr style='mso-yfti-irow: 0; mso-yfti-firstrow: yes; mso-yfti-lastrow: yes'>" &
   "<td style='border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; border-bottom: windowtext 1pt solid; padding-bottom: 0in; padding-top: 0in; padding-left: 5.4pt; border-left: windowtext 1pt solid; padding-right: 5.4pt; mso-border-alt: solid windowtext .5pt' valign='top' width='300'>" &
    "<p Class='MsoNormal' style='margin: 0in 0in 0pt'><span lang='ZH-CN' style='font-family: ; mso-ascii-font-family: 微软雅黑; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 微软雅黑'><font face='宋体'>"xx"</font></span></p>" &
     "<td style='border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; border-bottom: windowtext 1pt solid; padding-bottom: 0in; padding-top: 0in; padding-left: 5.4pt; border-left: windowtext 1pt solid; padding-right: 5.4pt; mso-border-alt: solid windowtext .5pt' valign='top' width='300'>" &
      "<p Class='MsoNormal' style='margin: 0in 0in 0pt'><span lang='ZH-CN' style='font-family: ; mso-ascii-font-family: 微软雅黑; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 微软雅黑'><font face='宋体'>"xx"</font></span></p>" &
       "<td style='border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; border-bottom: windowtext 1pt solid; padding-bottom: 0in; padding-top: 0in; padding-left: 5.4pt; border-left: windowtext 1pt solid; padding-right: 5.4pt; mso-border-alt: solid windowtext .5pt' valign='top' width='300'>" &
        "<p Class='MsoNormal' style='margin: 0in 0in 0pt'><span lang='ZH-CN' style='font-family: ; mso-ascii-font-family: 微软雅黑; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 微软雅黑'><font face='宋体'>"xx"</font></span></p>" &
         "<td style='border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; border-bottom: windowtext 1pt solid; padding-bottom: 0in; padding-top: 0in; padding-left: 5.4pt; border-left: windowtext 1pt solid; padding-right: 5.4pt; mso-border-alt: solid windowtext .5pt' valign='top' width='300'>" &
          "<p Class='MsoNormal' style='margin: 0in 0in 0pt'><span lang='ZH-CN' style='font-family: ; mso-ascii-font-family: 微软雅黑; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 微软雅黑'><font face='宋体'>"xx"</font></span></p>" &
           "<td style='border-top: windowtext 1pt solid; border-right: windowtext 1pt solid; border-bottom: windowtext 1pt solid; padding-bottom: 0in; padding-top: 0in; padding-left: 5.4pt; border-left: windowtext 1pt solid; padding-right: 5.4pt; mso-border-alt: solid windowtext .5pt' valign='top' width='300'>" &
            "<p Class='MsoNormal' style='margin: 0in 0in 0pt'><span lang='ZH-CN' style='font-family: ; mso-ascii-font-family: 微软雅黑; mso-fareast-font-family: 宋体; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: 微软雅黑'><font face='宋体'>"xx"</font></span></p>" &
             "</td>" &
             "</tr>" &
             "</tbody></table>" &
             "<br/><br/>Thank you! <br/> Best Regards"
           '添加附件
            item.Attachments.Add("此处需要输入上面新建ZipFile 的路径")
           '删除上面创建的压缩包,因为如果不删除没办法再次新建。
            My.Computer.FileSystem.DeleteFile("此处需要输入上面新建ZipFile 的路径")
            '邮件显示,或直接发送
            item.Display()  
            'item.send()

以上请大家参考,并提出意见,谢谢!

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值