+ Reply to Thread
Results 1 to 4 of 4

VBA for sending emails from Drafts folder was only for one use!

  1. #1
    Registered User
    Join Date
    05-25-2016
    Location
    Hollywood, CA
    MS-Off Ver
    2016
    Posts
    79

    VBA for sending emails from Drafts folder was only for one use!

    I used the code from the blog below to send multiple emails from my Drafts folder - it worked just fine a couple days ago... now I click the Quikaccess button in the exact same scenario and NOTHING happens! Is there ANY conceivable reason why this code would work fine one day and not function AT ALL another? Unbelievable!!

    https://www.datanumen.com/blogs/batch-send-multiple-draft-emails-outlook-vba/

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: VBA for sending emails from Drafts folder was only for one use!

    nothing happens generally means nothing is actually running

    the code only has two routes...both has msgbox's
    so are you getting any msgbox's at all?
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    05-25-2016
    Location
    Hollywood, CA
    MS-Off Ver
    2016
    Posts
    79

    Re: VBA for sending emails from Drafts folder was only for one use!

    No Msg boxes, nothing at all happens... so weird

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: VBA for sending emails from Drafts folder was only for one use!

    Can only assume your quikbutton is not running the correct code (or any code at all)

    can you still run the code manually ? if so just rebind it

+ 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. Replies: 3
    Last Post: 02-15-2018, 04:57 PM
  2. looking help to send all drafts folder mail ...
    By ks1102 in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 05-12-2017, 06:09 AM
  3. [SOLVED] Sending Outlook emails from Excel; Limits to three emails only?
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2013, 06:53 AM
  4. [SOLVED] Need Excell Macro to send out all the emails from Outlook Drafts folder
    By anto_01 in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 12-16-2012, 11:29 PM
  5. Replies: 0
    Last Post: 08-06-2012, 02:21 PM
  6. Automatically Sending emails to the folder in a local machine
    By VIJEXCEL in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 04-27-2011, 06:16 PM
  7. Sending macro emails using excel: Send emails with their passwords.
    By loveisblind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2009, 03:16 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