涉及邮件合并的奇怪场景
我需要为雇主执行一项涉及邮件合并的复杂任务。我们有一个 Excel 电子表格，其中包含以下列：姓氏、名字、电子邮件、出席（仅 X 表示出席，空白表示未出席）。我们有几个电子表格以相同的方式设置，每个电子表格大约有 350-400 行。电子邮件地址字段是该人员主管的电子邮件地址，因此我们列出了多个具有相同电子邮件地址的人员。
我应该做的是为参加电子表格的每个人创建证书。我知道如何通过邮件合并来做到这一点，但他们希望我如何组织它，这很奇怪。他们希望为每个电子邮件地址创建一个文件夹，并在该文件夹中包含属于该地址的证书。每个证书可以是其自己的文档，也可以是该电子邮件地址的一份文档中的所有页面。
有谁知道解决这个问题的最佳方法是什么？我知道如何从 Excel 电子表格创建邮件合并，但我只是不知道如何轻松创建所有文件夹并分离证书。
I have a complicated task I need to perform for my employer involving mail merge. We have an excel spreadsheet that has the following columns: last name, first name, email, attended (just an X for attended, blank for did not attend). We have a couple spreadsheets set up this same way each with about 350-400 rows. The email address field is the email address of the person's supervisor, so we have several people that have the same email address listed.
What I'm supposed to do is create certificates for every person that attended on the spreadsheet. I know how to do this with mail merge, but it's how they want me to organize it that is strange. They want a folder created for every email address and the certificates that belong with that address in that folder. Each certificate can either be its own document or they can all be pages in one document for that email address.
Does anyone have any idea as to what the best approach to this problem would be? I know how to create the mail merge from the excel spreadsheet I just don't know how to easily create all the folders and separate the certificates.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
如果您已经有了电子邮件地址部分，则似乎您需要一些文件/文件夹处理。只需看一下 VBA 中的 FSO（文件系统对象） 即可。
如果您有邮件地址列表，您只需为每个地址创建一个文件夹并将证书放在那里。
If you already have the email address part it seems you need some file/folder handling. Just have a look at the FSO (File System Object) in VBA.
If you have a list of the mail adresses you simply need to create a folder for each one and place the certificates there.