How can I automatically SEND all my emails in the DRAFTS folder of MS Outlook?
I inadvertently set my PDF-eXPLODE email connection configuration to go to the DRAFTS folder of MS Outlook (MAPI connection). I have tried dragging the emails from DRAFTS to OUTBOX folder and then clicking the SEND/RECEIVE button, but nothing happened. Now I believe I have to open each 'draft' email manually and then click SEND. I have more than 500 emails in the DRAFTS folder awaiting SEND. I need a way to send these automatically without having to open each one and click SEND thereby avoiding hours of work. Can this be done?
MS Outlook allows you to save many emails into the DRAFTS folder. However, there is no standard functionality that exists to be able to send those emails automatically in bulk, no ' SEND DRAFT EMAILS' button; however this can be achieved by copying and pasting the VBA program code below into a Outlook macro and assigning the macro to an Outlook ' Quick Access Toolbar ' button. Some of the following tip comes from https://www.datanumen.com/blogs/
Public Declare Sub Sleep Lib "kernel32" (ByVal Milliseconds As Long)
Dim objDrafts As Outlook.Items
On Error GoTo err_handle
' **** USE ONLY ON LARGE BATCHES OF (say) 500+ emails if you need to slow the program speed down ****
' **** TO USE THE PROGRAM LINE REMOVE THE SINGLE QUOTE ' IN FRONT OF 'SLEEP 2000 ****
If Err = "-2147467259" Then
The above screen shows you how your program code (white) window will look after you pasted a copy of the code from the yellow window. (The above is a MS Outlook 2010 window)
Highlight the project name at the top (in bold) in the left-hand pane and then change the name of the project in the Properties window below in the left hand pane - see image below
We now have to assign a button to this macro on to the Quick Access Toolbar in Outlook
If you want to exclude some of the emails in the Drafts folder from sending at this time, make a sub folder in Drafts like "On Hold". Then drag the emails you don't want to send into this sub folder. They will not get sent and when you are ready, just drag them back into the Drafts folder, then click your macro 'SendAllDraftEmails' run button.
This code is set up as a Macro within MS Outlook. Depending on your security setting for Macros, this Macro may not run at all. Contact your IT personnel if unsure. Here is where you can check your Macro settings: In MS Outlook, click on the menu File / Option / Trust Center. Next click on the button TRUST CENTER SETTINGS.... Next click on the Macro Settings menu item on the left pane:
The last two options will work with this program code.
As stated earlier in this KB article, if you have more than one email account set up in MS Outlook (see FILE/INFO/ACCOUNT SETTINGS) , then the 'SendAllDraftEmails' button will only send the emails from the Drafts folder of the account set as default.
If you have a paid PDF-eXPLODE Annual Support Plan, you can email us at email@example.com for help with any issue(s) you are having in getting this working.
|Posted - Sun, Mar 19, 2017 at 3:45 AM. This article has been viewed 38079 times.|
|Online URL: https://kb.pdf-explode.com/article/how-can-i-automatically-send-all-my-emails-in-the-drafts-folder-of-ms-outlook-79.html|
Powered by PHPKB (Knowledge Base Software)