Go Back   Access World Forums > Members List

 
dkinley has a spectacular aura about dkinley has a spectacular aura about

dkinley dkinley is offline

Access Hack by Choice

Visitor Messages

Showing Visitor Messages 1 to 1 of 1
  1. Kesh
    06-07-2012 07:36 AM
    Kesh
    Hi, My name is Kesh. I am using the code you posted to send e-mail:
    Dim sSubject As String
    Dim sToName As String
    Dim sDocName As String

    sDocName = "rptnewsletterdatabase"
    sSubject = "New Record Added for " & Me.ReferenceControlName
    sToName = "you@yourdomain.com"

    DoCmd.RunCommand acCmdSaveRecord
    DoCmd.SendObject acSendReport, sDocName, acFormatRTF, _
    sToName, , , sSubject, , False

    In my case it runs and opens the e-mail and I have to send manually. I would like tthe e-mail to be sent without any manual intervention. In a secon stage I want the e-mail to be sent at a specific time.

    Could you help me Please?
    Thank you

About Me

  • About dkinley
    Biography
    Making the world a better place by pissing people off; one person at a time.
    Location
    MidSouth, USA
    Interests
    Theoretical Research and Design
    Occupation
    Consulting Engineer

Statistics

Total Posts
Visitor Messages
Total Thanks
General Information
  • Last Activity: 07-26-2017 08:03 AM
  • Join Date: 07-28-2008
  • Referrals: 0

Friends

Showing Friends 1 to 1 of 1



All times are GMT -8. The time now is 12:05 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World