+ Reply to Thread
Results 1 to 4 of 4

Auto email script sends to many times?

  1. #1
    Registered User
    Join Date
    11-16-2014
    Location
    North America
    MS-Off Ver
    2013
    Posts
    8

    Auto email script sends to many times?

    Attached is a spread sheet we use to log data in our facility before automatically emailing it out at the times listed in "Menu" b7:b56. Everything works fine aside from the fact that it ends up emailing multiple times once it reaches the times we have set in b7:b56. I have tried a few things to remedy this but I have not been successful. I am pretty sure its an issue with the "export sheets" script and the loop timing that is causing this issue, but I am just not sure what the best way to remedy this is hence my reason for reaching out to smarter people then me lol. Thank you in advance for any help or opinions on this!!


    EOS Report.xlsm
    Last edited by gutchek; 12-11-2014 at 01:32 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    19,860

    Re: Need help with existing script

    Welcome to the forum. You have however violated two of our very important rules in your post.

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    Please take the time to read our rules that you agreed to when you joined this forum and abide by them in the future.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

  3. #3
    Registered User
    Join Date
    11-16-2014
    Location
    North America
    MS-Off Ver
    2013
    Posts
    8

    Re: Auto email script sends to many time?

    Apologies for the discrepancies in my post, it has been modified.

    Thanks.

  4. #4
    Registered User
    Join Date
    11-16-2014
    Location
    North America
    MS-Off Ver
    2013
    Posts
    8

    Re: Auto email script sends to many times?

    Anyone have any ideas on this? I'm pretty stuck on this one

    Thanks!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Where in an existing script would you add to a macro?
    By Castillb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-07-2013, 11:59 AM
  2. Minor modifications of existing script
    By Rawland Hustle in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2012, 12:08 PM
  3. Delete rows without numbers (modify existing script)
    By The Phil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-20-2011, 11:13 AM
  4. Adding nested if statement to existing script
    By adammark in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-29-2010, 12:31 AM
  5. Script that edits the text printed on the button that runs the script
    By petalred in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2008, 02:41 PM

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