Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Trenton, Ontario
    Posts
    175
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Send Email Macro (2000)

    I have never tried a macro in Outlook and I am in need of some help. Could someone show me a macro for Outlook that will create and send a new message every Friday night at 2:00am that sends to the same people with the same Excel attachment every week. (Outlook will already be running.)
    I've tried running this out of an Excel macro but I keep getting the "A program is trying send email on your behalf" message and that of course leaves it stuck in the middle of the night.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Send Email Macro (2000)

    The same problem would occur if you programmed it within Outlook itself. It is the result of the draconic security measures in recent updates/versions of Outlook. There are some ways around this:
    Express ClickYes from Express-Soft
    Outlook Redemption from Dmitry Streblechenko
    Both are free.

  3. #3
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Send Email Macro (2000)

    If you are connected to an SMTP server, there is a free utility called SMTPSend that can be run from a batch file, and thus run under the Scheduler without the need for Outlook to be running. Let me know if this may be of use and I'll search out the link...

  4. #4
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Trenton, Ontario
    Posts
    175
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Send Email Macro (2000)

    Thanks very much for your quick reply. The Express-Soft solution is the one I picked and it works seamlessly. If anyone has a similar problem you just download it and make sure it's running in your Tray and it looks after the rest. For my application there was no additional VB code required.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •