|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Sub 邮件合并_wdVBA()
Dim pf$
pf = ThisDocument.Path & "\将Excel数据对应写入已做好的Word模板的指定位置(统发).xls"
With ThisDocument.MailMerge
.MainDocumentType = wdNotAMergeDocument
.MainDocumentType = wdFormLetters
.OpenDataSource Name:=pf, LinkToSource:=True, _
Connection:="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=pf;Extended Properties=""HDR=YES;IMEX=1;"";Jet OLEDB:System database=", _
SQLStatement:="SELECT * FROM `数据$` where 姓名 is not null"
End With
With ThisDocument.Content.Find
Do While .Execute("数据001")
ThisDocument.MailMerge.Fields.Add .Parent, "姓名"
.Parent.Collapse 0
Loop
End With
With ThisDocument.Content.Find
Do While .Execute("数据002")
ThisDocument.MailMerge.Fields.Add .Parent, "基础工资"
.Parent.Collapse 0
Loop
End With
With ThisDocument.Content.Find
Do While .Execute("数据003")
ThisDocument.MailMerge.Fields.Add .Parent, "奖金"
.Parent.Collapse 0
Loop
End With
Application.ScreenUpdating = False
With ActiveDocument.MailMerge
.Destination = wdSendToNewDocument
.SuppressBlankLines = True
With .DataSource
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
End With
.Execute Pause:=False
End With
Application.ScreenUpdating = True
With ActiveDocument
.SaveAs ThisDocument.Path & "\工资通知(希望达到的效果).docx"
.Close 0
End With
MsgBox "完成并保存!"
End Sub |
评分
-
1
查看全部评分
-
|