Emailing From Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DS - 15 Jan 2006 20:04 GMT

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

Reply to this Message

DS - 15 Jan 2006 20:48 GMT

> I have this code that sends an E-Mail from Access it works great.
> I just need a few adjustments to complete it.
[quoted text clipped - 18 lines]
> False
> End Sub

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

Reply to this Message

Ron Weiner - 17 Jan 2006 11:54 GMT

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/.

Signature

Ron W
www.WorksRite.com

> > I have this code that sends an E-Mail from Access it works great.
> > I just need a few adjustments to complete it.
[quoted text clipped - 24 lines]
> Thanks
> DS

Reply to this Message

DS - 17 Jan 2006 13:32 GMT

> 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
[quoted text clipped - 6 lines]
> this product, but understand that it is effective. Here is a link
> http://www.dimastr.com/redemption/.

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

Reply to this Message

Ron Weiner - 17 Jan 2006 16:12 GMT

I have never even looked at the Msft Fax stuff, but a quick Google returned:

http://www.mvps.org/access/general/gen0009.htm

http://msdn.microsoft.com/msdnmag/issues/01/08/FaxServ/

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fax/faxlegacyvb
_7gdb.asp

I also saw a bunch of commericial software that promised to make sending
faxes easy.

Signature

Ron W
www.WorksRite.com

> > 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
[quoted text clipped - 12 lines]
> Once again......THANK YOU!
> DS

Reply to this Message