如何通过电子邮件发送由VBA中的MS Access查询生成的Excel文件？ [英] How to email an Excel file that has been generated by MS Access query in VBA?

问题描述

目前，以下代码从Access查询创建电子表格，并发送包含指向已保存文件位置的链接的电子邮件。有没有办法将电子表格附加到正在发送的电子邮件中，而不仅仅是给电子邮件收件人一个链接？谢谢。

Currently, the following code creates a spreadsheet from an Access query and sends an email containing a link to the location of the saved file. Is there a way I can attach the spreadsheet to the email being sent, rather than just give the email recipient a link? Thank you.

展开 | 选择 | Wrap | 行号

推荐答案

请参阅代码行＃ 12

Refer to Code Line# 12

展开 | 选择 | Wrap | 行号

太棒了！非常感谢!!

Fantastic! Thank you very much!!

非常欢迎你。

这篇关于如何通过电子邮件发送由VBA中的MS Access查询生成的Excel文件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！