Results 1 to 6 of 6
  1. #1
    Robert2150 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Location
    Sparks, Nv
    Posts
    102

    Emailing a Report from Access

    I have a database on a server at my clients location. I have developed a BUTTON to send reports by Email. The following is the code:



    Private Sub EmailEqRpt_Click()
    Dim strWhere As String

    strWhere = "[Property Number] = "& Me.[Property Number]
    DoCmd.OpenReport "RESERVE REQUIREMENT REPORT ADMIN", acPreview, ,strWhere
    DoCmd.SendObject acSendReport, "RESERVE REQUIREMENT REPORT ADMIN",acFormatPDF
    DoCmd.Close acReport, "RESERVE REQUIREMENT REPORT ADMIN", acSaveNo

    End Sub
    (this has been pasted from Word, and may not have the correct spacing.)

    This has been working fine using Windows Live Mail on the clients server, however, after June 30th I keep getting a Run Time '2293' Microsoft Access cannot send this Email.
    I have made the recommended adjustments to Windows Live Mail, given by Microsoft and the Windows Live Mail works fine on the server if I open Windows Live mail and just create an email. However, when within Access clicking on the "Email Report" button I get the aforementioned error.

    Any suggestions?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    I am not an expert with live mail. However, I guess that there is some missing information that you are not providing.

    The DoCmd method you illustrate there will use the default mail client on the machine. I do not believe you can do this through your browser. Automation of the browser is done another way.

  3. #3
    Robert2150 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Location
    Sparks, Nv
    Posts
    102
    When using the database users are logged onto the server and it operates just as if you were using your desktop computer, the default mail client on the server is Windows Live Mail, this all worked fine prior to Microsoft's changes on June 30th, and Windows Live Mail works fine on the server, if not in Access. I do not understand what the "Automation of the browser" has to do with emailing from the database.

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    What are you using for the Email Client, Outlook? I mentioned the browser because I understand Windows Live Mail as a browser based application.

  5. #5
    Robert2150 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Sep 2013
    Location
    Sparks, Nv
    Posts
    102
    Windows Live Mail is the Email Client refer to this link: https://en.wikipedia.org/wiki/Compar..._email_clients

  6. #6
    mrojas is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2013
    Location
    Concord California
    Posts
    72
    I have a Windows 10 Pro 64bit desktop, also installed is Outlook 2007 and Access 2016. I had the dreadful 2293 error message stating the email could not be sent. All had been working until a recent (five days ago 11/23/17) Windows Security update which caused the 2293 problem. I uninstall the security update and now all works as it has been for years. Good job Microsoft :-(

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Emailing Report
    By joecamel9166 in forum Access
    Replies: 3
    Last Post: 06-10-2016, 02:59 PM
  2. Emailing report in access
    By Robert2150 in forum Access
    Replies: 2
    Last Post: 09-27-2013, 10:39 PM
  3. Emailing monthly report through access 2007
    By andrewmo in forum Reports
    Replies: 1
    Last Post: 05-16-2012, 02:41 PM
  4. Replies: 3
    Last Post: 12-05-2011, 02:19 PM
  5. Emailing a report
    By prv in forum Access
    Replies: 1
    Last Post: 12-20-2010, 04:03 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums