邮件自动化 [英] Email automation

问题描述

我已经编写了几个SubRoutines用于通过嵌入式A97发送报告

VBA到OUtlook，但是想知道是否有办法发送来自

访问/ Outlook 2000每日发送一封电子邮件，让某些用户知道我的数据库的
备份已经运行。我想通过按下

按钮来实现这一点。


在Access97中，我使用的是可靠的：


DoCmd.SendObject acSendReport，MyReport，_ acFormatRTF，

" Jo ***** @ abcde.com"，"这是您的报告，错误


但是现在我在A2000并且只是想发送一条消息，没有

附件。只需要到 "收件人" "受试者QUOT; 消息正文


所以如果有人这样做我需要一些语法帮助吗？

I''ve written several SubRoutines for sending reports via embedded A97
VBA to OUtlook, but was wondering if there''s a way to send from
Access/Outlook 2000 a daily email letting certain users know that my
backups of their databases ran. I''d like to do this from the push of a
button.

In Access97 I was using the trusty:

DoCmd.SendObject acSendReport, "MyReport",_ acFormatRTF,
"Jo*****@abcde.com", , "Here is your report", , False

But now I''m in A2000 and just want to send a message, without an
attachment. Just need "To" "Recipients" "Subject" "Body of Message"

So I need some syntax help with my button if anyone has ever done this??

推荐答案

而不是'acSendReport使用acSendMoObject，并删除MyReport

和acFormatRTF

instead of "acSendReport use acSendMoObject, and delete the "MyReport"
and acFormatRTF

而不是'acSendReport使用acSendNoObject，并删除MyReport

和acFormatRTF

instead of "acSendReport use acSendNoObject, and delete the "MyReport"
and acFormatRTF

谢谢！这很好......还有一件事：如何处理

当电子邮件的正文很长时候回车：


" mcrClients在4月18日早上6:30运行（对于SA）

mcrQM_Pressmen在4月17日下午7:15运行（对于QM）

mcrIncoming在晚上7:15运行4 / 17（对于FG）

mcrQMgmt在4月17日下午7:15（对于QM）运行

Thanks! That works fine.... one more thing: What to do about handling
carriage returns when the body of the email is long like:

"mcrClients ran at 6:30am 4/18 (for SA)
mcrQM_Pressmen ran at 7:15pm 4/17 (for QM)
mcrIncoming ran at 7:15pm 4/17 (for FG)
mcrQMgmt ran at 7:15pm 4/17 (for QM)"

这篇关于邮件自动化的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！