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()
以上请大家参考,并提出意见,谢谢!