Total Access Email - Macro

Answered

Follow

Bmarthin

• October 13, 2021 16:09

I have a macro that runs and sends the email but then the macro pauses with TVE is displaying the progress and when done, it shows the number of messages sent and the time it took.. For the macro to go to the next step you must click OK.

 

I'm looking for a way to send out the blast in a macro that will not require clicking OK to move to the next step in the macro. The macro should run without any intervention as they will be ran using Total Visual Agent

 

This is frustrating as it seems like I have only traded the requirement to click the OK to send email from Outlook to click this OK button.

0

• Official comment

  

  Technical Support

  • October 14, 2021 16:02

  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
• 

  Allan

  • March 11, 2024 17:37

  How did you get it to work from a macro?

  Please advise

  0

  Comment actions Permalink
• 

  Technical Support

  • March 13, 2024 17:07

  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.