保存一个新的Word文档在Excel中的每一行 [英] Save a new Word Document for each row in Excel
问题描述
我有一个名称列表的Excel文件如下：
I have an Excel file with a list of names as follows:
*--------------------------------------*
| Last, First Middle | email@site.edu |
*--------------------------------------*
所有电子邮件地址@ site.edu
All email addresses are "@site.edu"
我有这样一个Word文件
I have a Word file like this
Dear <name>,
...
有没有办法自动保存插在名称单元格中的Word文档的副本，将文件保存为邮件，其中电子邮件是不site.edu？
Is there a way to automatically save a copy of the Word document with the name cell inserted over and save the file as "email" where "email" is the email address without site.edu?
我也想改变是中间名姓，但我可以处理通过保存Excel作为.csv和使用与常规的前pressions一个文本编辑器。我只是不知道足够的有关Office的功能，知道这是可能实现自动化。
I would also like to change to be First Middle Last, but I can handle that by saving the Excel as .CSV and using a text editor with regular expressions. I just don't know enough about the capabilities of Office to know if this is possible to automate.
推荐答案
这听起来像你只需要使用Word邮件合并功能，这将允许您使用Excel列表作为源文件的称呼名字，将创造个性化的信件/文档的每一行。然后他们可以打印整个合并文档。
It sounds like you just need to use Word's mail merge feature, which will allow you to use the Excel list as a source file for the salutation names and will create a personalized letter/document for each row. They could then print the whole merged document.
这篇关于保存一个新的Word文档在Excel中的每一行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
