如何使用sendobject从查询中向多个电子邮件地址发送报告？ [英] How to send a report to multiple email addresses from a query with sendobject?

问题描述

我想将特定报告RaceresultsR发送到名为Rt_EmailQ的查询中列出的电子邮件地址，查询中的字段名称称为电子邮件

仅代码如下显示空白To阻止手动添加地址

请帮助

i would like to send a specific report "RaceresultsR", to the email addresses listed in a query called Rt_EmailQ and the field name in query is called "Email"
The code below only show a blank "To" block to add addresses manually
please help

展开 | 选择 | Wrap | 行号

推荐答案

我的最爱电子邮件链接： http://www.granite.ab.ca/access /email.htm

My favorite email link: http://www.granite.ab.ca/access/email.htm

展开 | 选择 | Wrap | 行号

Thx Mr Adezzi ;

它只将Rt_EmailQ查询中的第一个电子邮件地址添加到收件人中。要发送的电子邮件的电子邮件列。


我希望代码能够获取此Rt_EmailQ（查询）中列出的所有电子邮件地址（在电子邮件文本字段中），添加它到To电子邮件中的地址由;分隔的地址对于名为RaceresultsR的报告。

然后我点击发送按钮然后关闭它。

到目前为止麻烦的问题。是否可以这样做？

Thx Mr Adezzi;
It only adds the first email address in the Rt_EmailQ query to the "To" email column of the email to be send.

I would like the code to take all the email addresses (in "email" text field) listed in this Rt_EmailQ (query), add it to the "To" column in the email where the addresses are separated by ";" for the report called "RaceresultsR".
I then click on the send button and off it go.
Thx for the trouble so far. Is it possible to do this?

这篇关于如何使用sendobject从查询中向多个电子邮件地址发送报告？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！