Emailing From Access

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I have this code that sends an E-Mail from Access it works great.
I just need a few adjustments to complete it.
First...I get a messagedox to select a profile...is there any way to
supress this?
Second...I get another message that pops up and asks if you know that
this Email is going to be sent and do you want to send it? I need for
this also not to come up. Any help appreciated.
Thanks
DS




Private Sub CommandEmail_Click()
DoCmd.SendObject _
acSendReport, _
"rptDays", _
acFormatRTF, _
Forms!EMail!EmailAddress, _
, _
, _
"Subject", _
"Message", _
False
End Sub
 
DS said:
I have this code that sends an E-Mail from Access it works great.
I just need a few adjustments to complete it.
First...I get a messagedox to select a profile...is there any way to
supress this?
Second...I get another message that pops up and asks if you know that
this Email is going to be sent and do you want to send it? I need for
this also not to come up. Any help appreciated.
Thanks
DS




Private Sub CommandEmail_Click()
DoCmd.SendObject _
acSendReport, _
"rptDays", _
acFormatRTF, _
Forms!EMail!EmailAddress, _
, _
, _
"Subject", _
"Message", _
False
End Sub
Click to expand...
OK I stand corrected. In addition to the above I also discovered the
problem. In order to actually send the E-Mail I have to open OutLook,
and hit send/receive. Not Good. I need it to send automatically. Any
help appreciated.
Thanks
DS
 
If you clients are win 2K or higher you might want to bypass Outlook on the
client entirely and use CDO to send the mail without any intervention by
the user. You can fin some sample code at
http://www.worksrite.com/CDOMail.htm. I have been using this code for quite
some time to allow unattended overnight update programs to communicate their
success or failure.

Another solution would be to use Redemption with Outlook. I have not used
this product, but understand that it is effective. Here is a link
http://www.dimastr.com/redemption/.
 
Ron said:
If you clients are win 2K or higher you might want to bypass Outlook on the
client entirely and use CDO to send the mail without any intervention by
the user. You can fin some sample code at
http://www.worksrite.com/CDOMail.htm. I have been using this code for quite
some time to allow unattended overnight update programs to communicate their
success or failure.

Another solution would be to use Redemption with Outlook. I have not used
this product, but understand that it is effective. Here is a link
http://www.dimastr.com/redemption/.
Click to expand...
HOLY SMOKES! This is great! This has got to be on the Top Ten List of
best Access Gadgets! Thank you so very much!!!! Now do you have
something similar for faxing?(No user Intervention):)
Once again......THANK YOU!
DS
 
Back
Top