Results 1 to 8 of 8
  1. #1
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Email From Access (2000)

    Hi,
    I am sending an email from Access. I'm wondering if there is a way to have it automatically send it without the user having to click send. I've looked at posts on this forum and I'm NOT getting that Yes, No message. My email comes up with the Email window and all the user has to do is click send. Can I automate that part?
    Thanks,
    Deb

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Email From Access (2000)

    Are you sending email using docmd.sendobject, or by automating outlook?

    Send Object takes an optional boolean paramater EditMessage. If this is set to false the message is sent directly without opening it in your email program.


    DoCmd.SendObject ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject, MessageText, EditMessage
    Regards
    John



  3. #3
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Email From Access (2000)

    I am using the SendObject. I'll give that a try. Thanks.

  4. #4
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Email From Access (2000)

    this is my code:
    Private Sub cmdSendReceiveReport_Click()
    DoCmd.SendObject acSendReport, "rptReceivingReport", acFormatSNP, _
    "debbie.buck@dla.mil", , , _
    "Recieved Parts Report Attached", _
    "Attached is the receiving report.", EditMessage = False
    End Sub

    and I'm still getting the message coming up and I have to click send.
    Thanks,
    Deb

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Email From Access (2000)

    I don't know if the "EditMessage = False" is a typo, it is not correct. Instead, try

    <code>DoCmd.SendObject acSendReport, "rptReceivingReport", acFormatSNP, _
    "debbie.buck@dla.mil", , , _
    "Received Parts Report Attached", _
    "Attached is the receiving report.", False</code>

    or

    <code>DoCmd.SendObject acSendReport, "rptReceivingReport", acFormatSNP, _
    "debbie.buck@dla.mil", , , _
    "Received Parts Report Attached", _
    "Attached is the receiving report.", EditMessage:=False</code>

    (I also changed Recieved to Received)

    If you get a message that a program is trying to send mail on your behalf, that is a security message introduced in one of the service packs for Outlook 2000. See <post#=423685>post 423685</post#> for a solution.

  6. #6
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Email From Access (2000)

    Just the False worked and now I am getting that security message. Do I have to install that software on every pc that will be sending the email for just the server where the dabase tables will be residing. I'll be splitting the database.
    Thanks,
    Deb

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Email From Access (2000)

    If you go for the ClickYes option, you will have to install it on every PC where the frontend database is used, not on the server with the backend database.

    If your users are all using Outlook with an Exchange server behind it, the Exchange administrator can change the server settings to suppress the security message. The Slipstick link in the post I referred to has details.

  8. #8
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Email From Access (2000)

    Ok, great, thanks Hans.
    Deb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •