每周报告自动化(Weekly report automatisation)

我必须编写自动邮件代码。 这是一份每周报告，包含文本，展望表和最新的Excel图表。 编辑：在发送之前，我需要检查邮件。

我不知道什么是更好的编码方式，我想要你的观点。

我的第一个选择是创建一个带有新宏的特殊工作簿，并使用这个新宏完成所有操作。 我没有看到管理多个其他工作簿和图表有任何问题。 但我不确定我是否可以轻松使用邮件。 是否可以从excel中编写/创建Outlook表？

我的第二个选择是与outlook合作。 我想我可以在某处编写一些代码来启动excel宏并更新我的表。 但我对此并不了解。

什么是更好的方法？

编辑：让我们说我只是一个小实习生（幸运的是，其他东西不是咖啡），报告是我经理的经理的经理。 没有灵活性。

I have to code an automated mail. This is a weekly report, containing texts, outlook tables, and up-to-dates excel charts. edit: before sending it, I need to check the mail.

I don't know what is the better way to code that and I want your point of view.

My first option is to create a special workbook with a new macro, and do everything with this new macro. I don't see any problem in managing multiple others workbooks and charts. But I am not sure if I can easyly works with the mail. Would it be possible to write/create table in outlook from excel ?

My second option is to work with outlook. I think I can write some code somewhere to launch excel macros and updates my tables. But i don't know much about this.

What would be the better approach ?

Edit: Let's say that I am just a little intern (lucky enough to make others thing than coffee), and the report is for my manager's manager's manager. No flexibility.

最满意答案

我只是通过电子邮件向他们发送包含报告信息的工作簿。 如果他们是贵公司的员工并且他们认出了您的电子邮件（或公司的电子邮件），则只需将工作簿作为附件发送给其中的所有报告，就不会出现安全问题。 你应该能够从Excel做到这一点： http ： //msdn.microsoft.com/en-us/library/office/ff458119（v = office.11​​）.aspx

您可以更新excel文件，然后将数据连接在一起以形成电子邮件正文（如果需要） - 如果需要，还可以显然通过电子邮件发送工作簿本身或其他更新的工作簿。

如果你是VBA的初学者，但肯定是可行的，那将是一个很大的项目。

I would just email them the workbook with the report information in it. If they are employees of your company and they recognize your email(or the company's email) there shouldn't be a security issue with just sending them the workbook as an attachment with all th reports in it. You should be able to do that from Excel: http://msdn.microsoft.com/en-us/library/office/ff458119(v=office.11).aspx

You can update the excel file and then concatenate your data together to form the email body as well if you want - as well as obviously email the workbook itself or another updated workbook if you want.

Would be a big project if you are a beginner with VBA but is certainly doable.

每周报告自动化(Weekly report automatisation)

我必须编写自动邮件代码。 这是一份每周报告，包含文本，展望表和最新的Excel图表。 编辑：在发送之前，我需要检查邮件。

我不知道什么是更好的编码方式，我想要你的观点。

我的第一个选择是创建一个带有新宏的特殊工作簿，并使用这个新宏完成所有操作。 我没有看到管理多个其他工作簿和图表有任何问题。 但我不确定我是否可以轻松使用邮件。 是否可以从excel中编写/创建Outlook表？

我的第二个选择是与outlook合作。 我想我可以在某处编写一些代码来启动excel宏并更新我的表。 但我对此并不了解。

什么是更好的方法？

编辑：让我们说我只是一个小实习生（幸运的是，其他东西不是咖啡），报告是我经理的经理的经理。 没有灵活性。

I have to code an automated mail. This is a weekly report, containing texts, outlook tables, and up-to-dates excel charts. edit: before sending it, I need to check the mail.

I don't know what is the better way to code that and I want your point of view.

My first option is to create a special workbook with a new macro, and do everything with this new macro. I don't see any problem in managing multiple others workbooks and charts. But I am not sure if I can easyly works with the mail. Would it be possible to write/create table in outlook from excel ?

My second option is to work with outlook. I think I can write some code somewhere to launch excel macros and updates my tables. But i don't know much about this.

What would be the better approach ?

Edit: Let's say that I am just a little intern (lucky enough to make others thing than coffee), and the report is for my manager's manager's manager. No flexibility.

最满意答案

我只是通过电子邮件向他们发送包含报告信息的工作簿。 如果他们是贵公司的员工并且他们认出了您的电子邮件（或公司的电子邮件），则只需将工作簿作为附件发送给其中的所有报告，就不会出现安全问题。 你应该能够从Excel做到这一点： http ： //msdn.microsoft.com/en-us/library/office/ff458119（v = office.11​​）.aspx

您可以更新excel文件，然后将数据连接在一起以形成电子邮件正文（如果需要） - 如果需要，还可以显然通过电子邮件发送工作簿本身或其他更新的工作簿。

如果你是VBA的初学者，但肯定是可行的，那将是一个很大的项目。

I would just email them the workbook with the report information in it. If they are employees of your company and they recognize your email(or the company's email) there shouldn't be a security issue with just sending them the workbook as an attachment with all th reports in it. You should be able to do that from Excel: http://msdn.microsoft.com/en-us/library/office/ff458119(v=office.11).aspx

You can update the excel file and then concatenate your data together to form the email body as well if you want - as well as obviously email the workbook itself or another updated workbook if you want.

Would be a big project if you are a beginner with VBA but is certainly doable.