发送邮件给多个收件人表单数据表视图 [英] Send Mail to Multiple Recipients Form Datasheet View

问题描述

我已在子窗体中发送分配给数据表的邮件按钮。如果我想向一个人发送邮件，可以正常工作，但如果我有多个选择，我希望它能正常工作。

我现在的代码是

I have send mail button assigned to datasheet in subform. Works fine if I want to send mail to one person, but I want it to work if I have multiple selection as well.
code I have now is

展开 | 选择 | Wrap | 行号

推荐答案

你需要一些代码才能做到这一点。

可以看到多项选择的效果： br $>
http://www.geocities.com/nico5038/xSample-Listbox-Datasheet-Up-Down2000.zip


用于收集所需的电子邮件地址。


Nic; o）

You''ll need some code to do this.
The effect of a multiple selection can be seen working in:
http://www.geocities.com/nico5038/xSample-Listbox-Datasheet-Up-Down2000.zip

Use this to collect the needed emailadresses.

Nic;o)

嘿nico5038

我尝试了你给我的数据库，它运行正常，我认为它有我需要的东西。

问题是当我拿代码并复制它时它不起作用。我创建了一个文本字段txtSelected。由于我没有使用顶部和高度的，我从代码中删除它们。无论如何，当我做出选择时，调试器显示类型不匹配并突出显示Set rs = me.recordesetclone line！

如何解决这个问题？有任何想法吗？顺便说一下，我使用Access 2000

Hey nico5038
I tried the DB you gave me and it works fine and it has what I need, I think.
Problem is that when I take the code and copy it it does not work. I created a text field txtSelected. As I have no use for the top and height ones I removed them from the code. Anyhow, when I make a selection debugger shows Type mismatch and highlights Set rs = me.recordesetclone line!
How can I fix this?? any ideas? btw I use Access 2000

好的......我得到了一些与一些不同的代码一起工作......清除了我所知道的一切并想出了这个

Ok... I got some of it to work with a bit of different code... scavenged all I know together and came up with this

展开 | 选择 | Wrap | 行号

这篇关于发送邮件给多个收件人表单数据表视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！