使用VBA生成电子邮件，调用特定单元格 [英] Generating an email, calling out specific cells, using VBA

问题描述

您好，

我想从VBA生成电子邮件以发送简短文本，以及附加excel文件。这个电子邮件需要包含/做的一些事情：

I want to generate an Email from VBA to send out a brief text, as well as attach the excel file. A couple of things this Email needs to contain/do:

1）生成电子邮件时需要保存此excel文件，文件名需要是在单元格中找到的显示文本B7。 

1) This excel file needs to save when the Email is generated, and the file name needs to be the shown text found in cell B7. 

2）电子邮件的主题必须是在单元格B7中找到的显示文本。

2) The subject of the email needs to be the shown text found in cell B7.

3）电子邮件需要包含excel文件作为附件。

3) The email needs to contain the excel file as an attachment.

4）电子邮件需要显示单元格B7中显示的文本。

4) The email needs to display the shown text found in cell B7.

我已经让VBA生成电子邮件，附上文件并显示文字，但是，我需要上面的具体4件事。 请看看。

I've got the VBA to generate the email, attach the file, and display the text, however, I need the specific 4 things from above.  Please have a look.

推荐答案

这是讨论Microsoft Excel功能的问题和反馈的论坛，我将把你的问题转到MSDN的Excel论坛

Hi,

This is the forum to discuss questions and feedback for Microsoft Excel features, I'll move your question to the MSDN forum for Excel

https://social.msdn.microsoft.com /论坛/ zh-CN / home？forum = exceldev

我们建议适当发布的原因是您将获得最合格的受访者群体以及其他阅读合作伙伴论坛定期可以分享他们的知识或从与我们的互动中学习。感谢您的理解。

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

这篇关于使用VBA生成电子邮件，调用特定单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！