发送邮件给多个收件人表单数据表视图 [英] 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屋!
查看全文