保存一个新的Word文档在Excel中的每一行

保存一个新的Word文档在Excel中的每一行

本文介绍了保存一个新的Word文档在Excel中的每一行的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有一个名称列表的Excel文件如下:

I have an Excel file with a list of names as follows:

*--------------------------------------*
| Last, First Middle | [email protected]  |
*--------------------------------------*

所有电子邮件地址@ 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中的每一行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-31 02:09