Private WithEvents appOL As Outlook.Application Private Sub appOL_NewMailEx(ByVal EntryIDCollection As String) ' YOUR CODE GOES IN HERE End Sub Private Sub Workbook_Open() Set appOL = GetObject(, "Outlook.Application") End Sub
|vba code in excel to save the current open mail item as .msg or .oft file in a location||23||62|
|InternetExplorer object in Excel VBA.||4||22|
|Excel printing page management||2||25|
|Excel 2016: auto-number column of merged cells.||47||31|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!