❶ Excel word 郵件合並如何生成多個文檔
Excel word郵件合並生成多個文檔的方法如下:
1、以office2010為例,假設需根據下圖Excel中的數據生成右邊Word文檔,每個同學單獨生成一張成績單。
❷ WORD郵件合並後如何生成多個文檔
你會用郵件合並嗎,先打開模板,然後選擇需要鏈接的資料庫,然後自動填充,然後合並輸出,生成的就是你需要的多個文檔(一個文件多頁),如果需要把每個頁分成一個文檔一個文檔,需要宏命令解決。
如何把一個word多頁文檔拆分為單頁或多頁(宏命令)
Option Explicit
Sub SplitPagesAsDocuments()
Dim oSrcDoc As Document, oNewDoc As Document
Dim strSrcName As String, strNewName As String
Dim oRange As Range
Dim nIndex As Integer
Dim fso As Object
Set fso = CreateObject("Scripting.FileSystemObject")
Set oSrcDoc = ActiveDocument
Set oRange = oSrcDoc.Content
oRange.Collapse wdCollapseStart
oRange.Select
For nIndex = 1 To ActiveDocument.Content.Information(wdNumberOfPagesInDocument)
oSrcDoc.Bookmarks("\page").Range.Copy
oSrcDoc.Windows(1).Activate
Application.Browser.Target = wdBrowsePage
Application.Browser.Next
strSrcName = oSrcDoc.FullName
strNewName = fso.BuildPath(fso.GetParentFolderName(strSrcName), _
fso.GetBaseName(strSrcName) & "_" & nIndex & "." & fso.GetExtensionName(strSrcName))
Set oNewDoc = Documents.Add
Selection.Paste
oNewDoc.SaveAs strNewName
oNewDoc.Close False
Next
Set oNewDoc = Nothing
Set oRange = Nothing
Set oSrcDoc = Nothing
Set fso = Nothing
MsgBox "結束!"
End Sub
❸ 郵件如何合並生成多個單個word文檔
操作方法人如下:
操作設備:戴爾電腦
操作軟體:Excel2017
1、Excel文件做好准備。