Create outlook email vba code#
Save the code and press the Alt + Q keys to close the Microsoft Visual Basic for Applications window.Ĥ. You will be reminded of the task at 9 am after one day. The start date of the task is the sent date of the message, and the task will be due in 3 days. Note: The message recipients and the message body will be added into the task body automatically. XRecipient = xRecipient & vbCrLf & Item.Body XRecipient = xRecipient & vbCrLf & Rcp.Address Set xTaskItem = Application.CreateItem(olTaskItem) XYesNo = MsgBox(xPrompt, vbYesNo + vbInformation, "Kutools for Outlook") XPrompt = "Do you want to create a task for this message?" VBA code: Auto create a task when sending email in Outlook Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) In the Microsoft Visual Basic for Applications window, copy the below VBA code into the ThisOutlookSession code window. Launch your Outlook, press the Alt + F11 keys to open the Microsoft Visual Basic for Applications window.Ģ. With the below VBA code, you can create a task automatically based on a sending email in Outlook. Here we are providing a method for you to quickly get it done.Īuto create a task when sending email in Outlook with VBA Sometimes, you may need to automatically create a task of an email when sending it in Outlook.
Create outlook email vba how to#
How to auto create a task when sending email in Outlook?
0 kommentar(er)
