Dim OutApp As Outlook.Application Dim OutMail As Outlook.MailItem Set OutApp = New Outlook.Application Set OutMail = OutApp.CreateItem(olMailItem)
and why do you have to have "(0)" after " "CreateItem" in the second example.
Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(0)
|First Blank Cell in a range||7||35|
|highlight duplicate entry||16||31|
|From msAccess SaveAs an excel file SILENTLY without opening excel||4||31|
|VBA to Find/Replace within a specified range in a Workbook||9||13|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
25 Experts available now in Live!