+ Reply to Thread
Results 1 to 4 of 4

Need help with Email Macro

  1. #1
    Registered User
    Join Date
    02-15-2018
    Location
    Vancouver, Canada
    MS-Off Ver
    2016
    Posts
    2

    Question Need help with Email Macro

    Hi
    so I was working on a stats report for my office. The macro is able to send out 20 emails to each staff for their weekly performance. Right now there are 14 staff, but the macro would only sent 12. Also, I'm a beginner in excel macro, so my code is very long. I was hoping to reduce it, but not sure how to use the Loop for Range. Hopefully someone can help me. Thanks

    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Need help with Email Macro

    What macro are you referring to?

  3. #3
    Registered User
    Join Date
    02-15-2018
    Location
    Vancouver, Canada
    MS-Off Ver
    2016
    Posts
    2
    Quote Originally Posted by davesexcel View Post
    What macro are you referring to?
    Thanks for replying. It is the EmailStatsCRR and EmailStatsCRR 2.
    Im not sure why if I run it for the first time, the macro works perfectly fine.

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Need help with Email Macro

    You can step through the macro, to find out what the problem is. At the beginning of the macro in the vba editor, hit F8 and it will follow the macro line by line each time you press F8

+ 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. attach different worksheet and email them tdifferent email address through macro/vba/addin
    By arunverma004 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-03-2014, 08:20 AM
  2. Email Macro - From excel sheet to Outlook email macro
    By juanes in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-30-2013, 01:59 PM
  3. Macro to PDF a sheet in workbook and email (outlook) to an email address in a cell
    By paul_sykes00 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-17-2012, 12:54 AM
  4. Replies: 2
    Last Post: 08-01-2012, 02:47 PM
  5. Excel Email Macro VBA - How to send an email once all required fields have been fille
    By wallacm2009 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2012, 10:51 AM
  6. Replies: 6
    Last Post: 12-02-2011, 02:14 PM
  7. Macro doesn't automatically resolve All email address when email is drafted
    By sonny.thind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2011, 12:58 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