如何通过Access项目中的代码发送电子邮件？ [英] How to send email via code in an Access Project?

问题描述

我有一个Access项目，我用它来允许客户端点击SQL

服务器在我的主人。这个项目有几种用于表格等的表格，但我也希望能够包含这个能力

来允许我的客户发送给每个订阅了

我们网站的人发一封电子邮件，转到包含姓名和电子邮件的表格

addy''s然后通过相同的方式循环发送通过

向他们发送电子邮件，将他们的地址附加到电子邮件TO：field ..或BCC<我在ASP和VB中已经完成了

，但是没有访问..我当然会在我的托管服务提供商处使用

SMTP服务器为此..有人能指点我这么做一些示例代码吗？我正在使用Access 2002 / Office pro 2002 ..

谢谢


Tim


***通过开发人员指南 http://www.developersdex.com 发送***

不要只是参加USENET ......获得奖励！

解决方案

Tim Smallwood< do ***** **@netscape.net>写道：

我有一个Access项目，我用它来允许客户端访问我的主机上的SQL
服务器。这个项目有几种用于表格等的表格，但是我也希望能够包含允许我的客户向已订阅的所有人发送电子邮件的能力。
我们的网站转到包含名称和电子邮件的表格
addy''s然后通过相同的方式循环并发送电子邮件给他们所有人通过
将他们的地址附加到电子邮件TO：field ..或BCC<我已经在ASP和VB中完成了这个，但是没有访问..我当然会在我的托管服务提供商处使用
SMTP服务器。有人可以指点我要这样做的一些示例代码？我正在使用Access 2002 / Office pro 2002 ..

请参阅示例代码，说明在Access上循环访问DAO记录集页面

通过 http：//www.granite.ab发送电子邮件常见问题解答。 ca / access / email / recordsetloop.htm


Tony


-

Tony Toews ，Microsoft Access MVP

请仅在新闻组中回复，以便其他人可以阅读整个消息主题。

Microsoft Access Links，Hints ，提示&会计系统
http://www.granite.ab.ca /accsmstr.htm

" Tim Smallwood" <做******* @ netscape.net>在消息中写道

news：40 ********************* @ news.frii.net ...

我有一个Access项目，我用它来允许客户端访问我的主机上的SQL
服务器。这个项目有几种用于表格等的表格，但是我也希望能够包含允许我的客户向已订阅的所有人发送电子邮件的能力。
我们的网站转到包含名称和电子邮件的表格
addy''s然后通过相同的方式循环并发送电子邮件给他们所有人通过
将他们的地址附加到电子邮件TO：field ..或BCC<我已经在ASP和VB中完成了这个，但是没有访问..我当然会在我的托管服务提供商处使用
SMTP服务器。有人可以指点我要这样做的一些示例代码？我正在使用Access 2002 / Office pro 2002 ..
谢谢

http://www.aspfaq.com/show.asp?id=2403

Tony，


非常感谢..我现在在网站上，这是一个多么伟大的网站..爱

UI设计的东西。 。

Tim


***通过Developersdex发送 http://www.developersdex.com ***

不要只是参加USENET ......获得奖励！

Hi,

I have an Access project that I use to allow a client to hit an SQL
server at my host. This project has several forms that are used to
udpate tables, etc, but I''d also like to be able to include the ability
to allow my client to send an email to everyone that has subscribed to
our web site by going to the table that contains the names and email
addy''s and then loop thru the same and send an email to them all by
appending their address to the email TO: field.. or BCC< etc.. I''ve done
this in ASP, and VB, but not in access.. I of course will be using the
SMTP server at my hosting provider for this.. Can someone point me to
some sample code to do this? I''m using Access 2002 / Office pro 2002..
Thanks

Tim

*** Sent via Developersdex http://www.developersdex.com ***
Don''t just participate in USENET...get rewarded for it!

解决方案

Tim Smallwood <do*******@netscape.net> wrote:

I have an Access project that I use to allow a client to hit an SQL
server at my host. This project has several forms that are used to
udpate tables, etc, but I''d also like to be able to include the ability
to allow my client to send an email to everyone that has subscribed to
our web site by going to the table that contains the names and email
addy''s and then loop thru the same and send an email to them all by
appending their address to the email TO: field.. or BCC< etc.. I''ve done
this in ASP, and VB, but not in access.. I of course will be using the
SMTP server at my hosting provider for this.. Can someone point me to
some sample code to do this? I''m using Access 2002 / Office pro 2002..

See the Sample Code illustrating looping through a DAO recordset page at the Access
Email FAQ at http://www.granite.ab.ca/access/email/recordsetloop.htm

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

"Tim Smallwood" <do*******@netscape.net> wrote in message
news:40*********************@news.frii.net...

Hi,

I have an Access project that I use to allow a client to hit an SQL
server at my host. This project has several forms that are used to
udpate tables, etc, but I''d also like to be able to include the ability
to allow my client to send an email to everyone that has subscribed to
our web site by going to the table that contains the names and email
addy''s and then loop thru the same and send an email to them all by
appending their address to the email TO: field.. or BCC< etc.. I''ve done
this in ASP, and VB, but not in access.. I of course will be using the
SMTP server at my hosting provider for this.. Can someone point me to
some sample code to do this? I''m using Access 2002 / Office pro 2002..
Thanks

http://www.aspfaq.com/show.asp?id=2403

Tony,

Thanks so much.. I''m at the site now, and what a great web site.. Love
the UI design stuff..
Tim

*** Sent via Developersdex http://www.developersdex.com ***
Don''t just participate in USENET...get rewarded for it!

这篇关于如何通过Access项目中的代码发送电子邮件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！