Results 1 to 14 of 14
  1. #1
    NickG is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Oct 2015
    Posts
    7

    Microsoft Access can't send this email message using Microsoft Access 2013 Runtime

    I have a macro built to email the current record and it works great when using Access but when the rest of the people using the database using Microsoft Access 2013 Runtime i receive an error "Before attempting to send an e-mail message from Microsoft Access, resolve the problem identified in the previous message, or configure your computer to send and receive email messages." outlook is set up and receiving and sending fine. I believe it to be the Microsoft Access 2013 Runtime causing the issue.

    Please any help would be Great

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,349
    All persons are using the EXACT version of Outlook?

    (it could be a kink in the runtime, since my users could not use control Excel, like you're using Outlook)

  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,863
    I do not use Macros but I would be concerned what version of Access the macro was created in. You mentioned the clients are using RT 2013. What version of Access was used to develop the app and create the Macro?

  4. #4
    NickG is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Oct 2015
    Posts
    7
    Quote Originally Posted by ItsMe View Post
    I do not use Macros but I would be concerned what version of Access the macro was created in. You mentioned the clients are using RT 2013. What version of Access was used to develop the app and create the Macro?
    2013 Home and Business both 64 bit

  5. #5
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,863
    Perhaps the Macro is looking for a specific Outlook Account that is not available on the other computers? What does Macro mean to you? In Access, a Macro is not VBA code. Perhaps the best thing to do is to use VBA to automate Outlook or use a built in VBA function or method to send an email.

  6. #6
    NickG is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Oct 2015
    Posts
    7
    Private Sub cmdEmailIssue_Click()
    DoCmd.RunCommand acCmdSaveRecord
    DoCmd.SetFilter "", "[tblContact]![ID]=[Forms]![frmContactBrittani]![ID]", ""
    DoCmd.SendObject acForm, "frmContactBrittani", "PDFFormat(*.pdf)", "", "", "", "Immediate Response", "", True, ""
    DoCmd.RunCommand acCmdRemoveFilterSort


    End Sub



    Now it is giving a runtime error.

    any help would be great i apologize i am not great with vba has been a few years since i had done vba

  7. #7
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,863
    It is giving you an error in the Full version of Access? What does the error say? Which line is causing the exception? You can click OK at the time of the Run Time error to launch the debugger.

    Perhaps you can leave off the last argument in the Send Object method. This argument is looking for a path to a template. The parameter is of type Variant. Passing it an empty string will change it from being an empty state and might cause the Method to look for a path.
    Code:
    DoCmd.SendObject acForm, "frmContactBrittani", "PDFFormat(*.pdf)", "", "", "", "Immediate Response", "", True

  8. #8
    NickG is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Oct 2015
    Posts
    7
    it is not giving me any error in the full version and it would not let me remove the last argument

  9. #9
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,863
    Is any code running in the clients with RT? You need to allow Macros and Code to run. When the app launches in RT, you should get a prompt to accept the risk. What happens if you place a message box in the On Load event of the form that launches with the app?
    MsgBox "Hello World"

  10. #10
    NickG is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Oct 2015
    Posts
    7
    form loads fine and the rest of the functionality of the database works. just when trying to email the single form is when the error occurs. and yes when initial loading it gives the warning

  11. #11
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,863
    I just tested the following in an accdr
    DoCmd.SendObject acForm, "frmContactBrittani", "PDFFormat(*.pdf)", "", "", "", "Immediate Response", "", True, ""

    I did not have any issues. Perhaps Outlook is launching a dialog box that is not realized by the user. I still do not know what the error message is saying when you are using VBA in RT.

    Also, I had no problem with the following
    DoCmd.SendObject acForm, "frmContactBrittani", "PDFFormat(*.pdf)", "", "", "", "Immediate Response", "", True

  12. #12
    NickG is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Oct 2015
    Posts
    7

  13. #13
    NickG is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Oct 2015
    Posts
    7
    Would it make a difference i am trying to use the RT on other workstations, is it trying to open "my" outlook and not their own?

  14. #14
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,863
    Quote Originally Posted by NickG View Post
    ...is it trying to open "my" outlook and not their own?
    No, it is not. I was trying to make sense of why the Macro was causing an issue when I suggested that. However, the VBA you are using is not looking for a specific name for an Outlook account.

    I suggest you do as I did and create a new, sample Access file. Copy a small table into your new DB for testing purposes. Create a form and name it, "frmContactBrittani". Bind your form to the table and place your code behind a command button. Test the new app in the RT environment.

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

Similar Threads

  1. Microsoft Access 2010 Runtime on windows 8
    By Guy Tal in forum Access
    Replies: 1
    Last Post: 02-16-2014, 10:59 AM
  2. Microsoft Access 2013 Web Control question
    By edanMimran in forum Access
    Replies: 13
    Last Post: 11-15-2013, 06:25 AM
  3. SQL Query challenge in Microsoft Access 2013
    By Bingfoot in forum Queries
    Replies: 5
    Last Post: 10-07-2013, 07:58 AM
  4. Microsoft Access Runtime Question
    By kgbo in forum Access
    Replies: 2
    Last Post: 08-30-2013, 02:35 AM
  5. Microsoft Access Runtime switches
    By Owl in forum Access
    Replies: 1
    Last Post: 06-11-2011, 06:20 PM

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 - Senior Forums