Total Access Email - Macro

Answered

Comments

3 comments

  • Official comment
    Avatar
    FMS Technical Support

    What command are you running in the macro to call Total Access Emailer?

    Are you using the TotalAccessEmailer function defined in https://fmsinc.com/MicrosoftAccess/email/vba-programmatic.html?

    It has parameters to determine what to show to the user and if you want to show the results so they press OK. 

    The VBA programmatic interface of Total Access Emailer lets you hide the program completely from your user. The Code Generator form lets you set the options visually.

    Hope this helps.

    Comment actions Permalink
  • Avatar
    Allan

    How did you get it to work from a macro?

    Please advise

    0
    Comment actions Permalink
  • Avatar
    FMS Technical Support

    The first step is to make sure the procedure that runs the Total Access Emailer function works, independent of running it from a macro. Details are here: https://fmsinc.com/MicrosoftAccess/email/vba-programmatic.html

    Make sure the function is in a module as a public function. Verify it compiles and works by running the function successfully (from an event or Immediate Window). It can then be called from a macro like any other VBA function using the macro RunCode command.

    0
    Comment actions Permalink

Please sign in to leave a comment.