ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    Best way to automate an email sending with macros

    IT Business
    4
    4
    1.0k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • S
      Sparkum
      last edited by

      Hey guys.

      We need to automate the running of macros and sending of an email every day (if outlook is open or not) what would be the best way to go about this?

      We just started doing this about a week ago, for speed we got it up and it runs successfully when outlook is open but we obviously wanna take that out of the loop of things that could go wrong.

      I assume my obvious answer is task scheduler with VB scripts?

      Thanks

      L DanpD 2 Replies Last reply Reply Quote 1
      • StrongBadS
        StrongBad
        last edited by

        From where does it need to send out? A common way to handle this is with a script, not a macro. Do you need to send from an application (Word, Outlook) or just send an email?

        I don't know the right answer on Windows, on Linux you would just use the mail command. Assume that the message to send is stored in "daily.txt" then you would just send...

        mail -s "Your Daily Mail" [email protected] < daily.txt
        

        And you could then pop that one line into the crontab to make it send automatically.

        1 Reply Last reply Reply Quote 3
        • L
          LAH3385 @Sparkum
          last edited by

          @Sparkum

          AHK + batch can also accomplish this. I saw a tut on how to use AHK with cmd and put in batch file + combine with task schedule to send emails. I don't have the link but I am sure AHK can help you compose and send it out...assuming you want to send the same message everyday.

          I was planning on setting something like that to send me update on my bot (ragnarok online) back in the day. The script I wrote involve taking screenshot, email screenshot to my email. 😄

          1 Reply Last reply Reply Quote 0
          • DanpD
            Danp @Sparkum
            last edited by

            @Sparkum I've done similar with AutoIT.

            1 Reply Last reply Reply Quote 0
            • 1 / 1
            • First post
              Last post