+ Reply to Thread
Results 1 to 2 of 2

VBS/OutMail script and macro sends email message twice

  1. #1
    Registered User
    Join Date
    11-11-2011
    Location
    Maine, USA
    MS-Off Ver
    Excel 2010, Windows 7 or XP
    Posts
    16

    VBS/OutMail script and macro sends email message twice

    Good afternoon.
    I am having a bit of a problem that I can't quite figure out. Below is portion of my code which sends an email from an Excel macro:

    Please Login or Register  to view this content.
    Now, this code works great if I run it directly from Excel. The problem arises when I call it from a VBScript, the relevant code is displayed below:
    Please Login or Register  to view this content.
    When I run it from the VBScript, two emails are sent. I realize this isn't the biggest problem, but it is annoying and I'd like to know why. If anyone could help with this, that would be great!

  2. #2
    Registered User
    Join Date
    11-11-2011
    Location
    Maine, USA
    MS-Off Ver
    Excel 2010, Windows 7 or XP
    Posts
    16

    Re: VBS/OutMail script and macro sends email message twice

    So I found a solution to this on another forum.
    Apparently the problem is that there was a hidden version of Excel in memory that was also sending. The solution is to use
    Please Login or Register  to view this content.
    And call the StartUp() macro from the VBS. Dirty, but it works.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1