在Outlook电子邮件正文中发送访问报告 [英] Send Access report in body of Outlook email

问题描述

有没有办法将报表中的数据/信息插入到Outlook电子邮件正文中？


我希望VBA代码从我的报告中提取数据，将其输入到我的电子邮件正文中，然后发送，而不使用任何附件。


感谢您的帮助！

解决方案

ryaan，


有有几种方法可以做到这一点，但最好的方法是使用记录集从数据库中提取特定数据，然后构建电子邮件的正文文本，然后使用SendObject方法发送它。还有其他方法，但也取决于你的喜好。


你到目前为止尝试了什么？

Hi Twinnyfo，

我已经尝试过记录集，但我无法让它工作。我有一份名为TripCSA的报告。包含我想要包含的所有数据。我想把所有数据都放在我的Outlook电子邮件正文中。


提前谢谢，

Ryan

< blockquote>您需要在该报告下提供报告和查询的示例。记录集怎么可能无法上班？


在我们任何人甚至可以开始帮助您之前，您需要提供有关您的数据库和所需结果的更多信息。根据您的报告，这可能相当简单，或者相当复杂......但由于我们甚至不知道您的报告是什么样的，或者背后的数据，我无法估计。

Is there a way to insert data/information from a report into the body of an Outlook email message?

I want the VBA code to pull the data from my report, input it into the body of my email message, and then send, without using any attachments.

Thanks for any assistance!

解决方案

ryaan,

There are several ways to do this, but hte best is to use a recordset to pull the specific data from your database, then build the Body Text of your e-mail and then send it, using the SendObject method. There are other ways, also, but just depends on your preferences.

What have you tried so far?

Hi Twinnyfo,

I''ve tried the recordset, but I can''t get it to work. I''ve got a report called "TripCSA" that contains all the data I want to include. I want to take all that data and put it in my Outlook email body.

Thanks in advance,
Ryan

You will need to provide examples of your report and queries underneath that report. What about the recordset could you not get to work?

You will need to provide moreinformaiton about your database and your desired result before any of us can even begin to assist you with this. Depending on your report, this could be rather simple, or rather complex.... But since we don''t even know what your report looks like, or the data behind it, I can''t estimate that.

这篇关于在Outlook电子邮件正文中发送访问报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！