After sending an email with voting buttons, you’ll receive the voting responses from the recipients. Yet, at times, there may be some recipients who haven’t voted. In this case, you may hope to send a notification mail to them. This article will assist you to get it in quick time.
Outlook allows users to send an email with voting buttons. If you’ve sent such an email to many recipients, you’ll surely hope to get their voting responses as soon as possible. Nevertheless, if you discover that some recipients still have not voted after some days, you may wish to send a notification email to them. In this case, it demands you to extract the recipients manually by standard means, which is a bit troublesome. Now, in the followings, we’ll introduce another handier way to you.
Send a Notification Email to Those Haven’t Voted
- At the very outset, tap on “Alt + F11” to trigger Outlook VBA editor.
- Then, copy and paste the following code into an unused module.
Sub SendNotification_ThoseNotVoted() Dim objMail As Outlook.MailItem Dim objRecipient As Outlook.Recipient Dim objNotification As Outlook.MailItem Select Case Application.ActiveWindow.Class Case olInspector Set objMail = ActiveInspector.CurrentItem Case olExplorer Set objMail = ActiveExplorer.Selection(1) End Select 'Create a notification email Set objNotification = Outlook.Application.CreateItem(olMailItem) 'Add those who haven't voted to the notification email as recipients For Each objRecipient In objMail.Recipients If objRecipient.TrackingStatus = olTrackingNone Then objNotification.Recipients.Add objRecipient.Address Else If objRecipient.AutoResponse = "" Then objNotification.Recipients.Add objRecipient.Address End If End If Next 'Set the notification email details With objNotification .Recipients.ResolveAll .Subject = "Please Vote!!!" .Body = "Please vote as soon as possible!!" .Attachments.Add objMail '.Send ==> To directly send out .Display End With End Sub
- After that, for later convenience, add this macro to Quick Access Toolbar with reference to “How to Run VBA Code in Your Outlook“.
- Eventually, take the operations below to run this macro.
- First off, select or open the original email with voting buttons.
- Then, click the macro button in Quick Access Toolbar.
- At once, a new email will display, like the screenshot below. It’s included the original recipients who haven’t voted in the “To” field. And its subject and body have been set as per the predefined values in the code.
Cope with Annoying Outlook Problems
Similar to other applications, Outlook can be subject to a variety of issues, such as crash, freeze, frequent error messages, etc. without any doubts, no one is willing to encounter them. However, it’s admittedly difficult to avoid them. What you can do is to stick to backing up your Outlook file regularly, such that even if your PST file is corrupt, you still can get back valuable Outlook data without need to repair PST.
Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including damaged mdf and outlook repair software products. For more information visit www.datanumen.com