将查询结果传递给SendObject [英] passing query results to SendObject

问题描述

嘿，

我试图通过查询结果自动发送与他们自己相关的人报告。


我可以拿e从ListBox发送邮件地址并将它们传递给SendObject命令，但我想取一个记录集（从查询中获取）并传递给它。



''* ****当前代码*****

Hey,
I am trying to take the results of a query to auto-email people reports only relating to themselves.

I can take e-mail addresses from a ListBox and pass them to the SendObject command but I want to take a record set (gained from a query) and pass instead.


''*****CURRENT CODE*****

展开 | 选择 | Wrap | 行号

推荐答案

什么是利益相关者查询的SQL？

What is the sql of "stakeholders query"?

这只是一个电子邮件地址列表当项目编号等于同一表单上的控件工具箱时，将拉出。


因此，如果您选择项目编号，则应将该项目的报告通过电子邮件发送给该项目的人员。我想我需要打开查询，创建一个变量数组来拉取所有值，然后关闭查询。我无法让它工作。


我在XP中使用Access 2003工作。

It is simply a list of e-mail addresses pulled when a project number is equal to a control toolbox on the same form.

So if you pick a project number if should e-mail the report of that project to just the people working on that project. I think I need to open the query, make a variable array to pull all the values and then close the query. I just can''t get it to work.

I am working in XP with Access 2003.

展开 | 选择 | Wrap | 行号

试试这个....

Try this ....

展开 | 选择 | 裹 | 行号

这篇关于将查询结果传递给SendObject的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！