word文档怎么合并邮件？撤销工作表保护密码方法看这里

word文档怎么合并邮件

1、打开需要进行邮件合并的word文档，浏览要插入的数据。

2、在菜单栏----邮件菜单----开始邮件合并----邮件合并分步向导，在文档的左边出现“ 邮件合并 ”对话栏。

3、选择文档类型为“ 信函 ”(将信函发送给一组人，可以设置信函的格式)，单击“下一步”继续。

4、点击下一步(正在启动文档)---选择开始文档，就是需要设置信函，选中“ 使用当前文档 ”，单击“下一步”。

5、点击下一步(选取收件人)---选择收件人，勾中“使用现在列表”，点击“浏览...”(使用来自某文件或数据库的姓名和地址。)，选择数据源，找到需要添加的数据源地址---选择表格，的名称SHEET1$，和选中数据首行包含列标题。并点击确定按钮，---选择“邮件合并收件人”把需要的收件人列表勾中，在此不可以调整收件人列表，比如：排序，筛选，查找重复收件人，查找收件人，验证地址---点击确定。

6、回到“邮件合并”栏，选择下一步：撰写信函，选中“其他项目”---出现“插入合并域”，根据需要合并的邮件内容，选择域的内容。比如:姓名栏后面添加姓名域，性别栏添加性别域等等。插入完后，点击关闭。单击“下一步”预览信函---可以就看到第一条记录。

7、点击“ 下一步 ”完成邮件合并---完成合并，已经可以使用“邮件合并”生成信函----点击“编辑单个信函”---选择合并全部记录。左边可以看到，记录的全部内容。此时就可以打印，需要的内容。

8、邮件合并完成。注：如果要修改，就可以点击“上一步”来实现修改，其他操作和上述相同。

撤销工作表保护密码

撤销工作表保护密码方法：

2007版Excel表格中可以按照以下方式建宏：

1、打开Excel表格中的Excel选项，选择自定义，得到如下画面：

撤销工作表保护密码 刷卡记录表如何撤销工作表保护密码

2、然后在左边侧框栏中选择“查看宏”之后双击或者选择添加按钮，则可以看到右边栏中有了查看宏按钮，之后点击右下角的确定。

撤销工作表保护密码 刷卡记录表如何撤销工作表保护密码

3、大家可以在下面这个窗口处看到箭头所指的按钮：点击按钮，之后弹出窗口：

撤销工作表保护密码 刷卡记录表如何撤销工作表保护密码

撤销工作表保护密码 刷卡记录表如何撤销工作表保护密码

4、在宏名处填写一个名字(可随意)，然后点击创建，弹出以下窗口：

撤销工作表保护密码 刷卡记录表如何撤销工作表保护密码

撤销工作表保护密码 刷卡记录表如何撤销工作表保护密码

5、将窗口内的内容全选后删除，然后将下面分割线以内的内容开始复制粘贴在上面的窗口内：

撤销工作表保护密码从横线下开始复制

------------------------------------------------------------------------------------------

Option Explicit

Public Sub AllInternalPasswords()

' Breaks worksheet and workbook structure passwords. Bob McCormick

' probably originator of base code algorithm modified for coverage

' of workbook structure / windows passwords and for multiple passwords

'

' Norman Harker and JE McGimpsey 27-Dec-2002 (Version 1.1)

' Modified 2003-Apr-04 by JEM: All msgs to constants, and

' eliminate one Exit Sub (Version 1.1.1)

' Reveals hashed passwords NOT original passwords

Const DBLSPACE As String = vbNewLine & vbNewLine

Const AUTHORS As String = DBLSPACE & vbNewLine & _

"Adapted from Bob McCormick base code by" & _

"Norman Harker and JE McGimpsey"

Const HEADER As String = "AllInternalPasswords User Message"

Const VERSION As String = DBLSPACE & "Version 1.1.1 2003-Apr-04"

Const REPBACK As String = DBLSPACE & "Please report failure " & _

"to the microsoft.public.excel.programming newsgroup."

Const ALLCLEAR As String = DBLSPACE & "The workbook should " & _

"now be free of all password protection, so make sure you:" & _

DBLSPACE & "SAVE IT NOW!" & DBLSPACE & "and also" & _

DBLSPACE & "BACKUP!, BACKUP!!, BACKUP!!!" & _

DBLSPACE & "Also, remember that the password was " & _

"put there for a reason. Don't stuff up crucial formulas " & _

"or data." & DBLSPACE & "Access and use of some data " & _

"may be an offense. If in doubt, don't."

Const MSGNOPWORDS1 As String = "There were no passwords on " & _

"sheets, or workbook structure or windows." & AUTHORS & VERSION

Const MSGNOPWORDS2 As String = "There was no protection to " & _

"workbook structure or windows." & DBLSPACE & _

"Proceeding to unprotect sheets." & AUTHORS & VERSION

Const MSGTAKETIME As String = "After pressing OK button this " & _

"will take some time." & DBLSPACE & "Amount of time " & _

"depends on how many different passwords, the " & _

"passwords, and your computer's specification." & DBLSPACE & _

"Just be patient! Make me a coffee!" & AUTHORS & VERSION

Const MSGPWORDFOUND1 As String = "You had a Worksheet " & _

"Structure or Windows Password set." & DBLSPACE & _

"The password found was: " & DBLSPACE & "$$" & DBLSPACE & _

"Note it down for potential future use in other workbooks by " & _

"the same person who set this password." & DBLSPACE & _

"Now to check and clear other passwords." & AUTHORS & VERSION

Const MSGPWORDFOUND2 As String = "You had a Worksheet " & _

"password set." & DBLSPACE & "The password found was: " & _

DBLSPACE & "$$" & DBLSPACE & "Note it down for potential " & _

"future use in other workbooks by same person who " & _

"set this password." & DBLSPACE & "Now to check and clear " & _

"other passwords." & AUTHORS & VERSION

Const MSGONLYONE As String = "Only structure / windows " & _

"protected with the password that was just found." & _

ALLCLEAR & AUTHORS & VERSION & REPBACK

Dim w1 As Worksheet, w2 As Worksheet

Dim i As Integer, j As Integer, k As Integer, l As Integer

Dim m As Integer, n As Integer, i1 As Integer, i2 As Integer

Dim i3 As Integer, i4 As Integer, i5 As Integer, i6 As Integer

Dim PWord1 As String

Dim ShTag As Boolean, WinTag As Boolean

Application.ScreenUpdating = False

With ActiveWorkbook

WinTag = .ProtectStructure Or .ProtectWindows