PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
On Error Resume Next Dim objOL As Object 'check if Outlook is running Set objOL = GetObject(, "Outlook.Application") 'on error start Outlook If Err.Number <> 0 Then ' Err.Clear Shell "C:\Program Files\Microsoft Office\Office14\outlook.exe", vbMinimizedFocus DoEvents End If Set olApp = CreateObject("Outlook.Application") Set olMsg = olApp.CreateItem(0) With olMsg .Subject = "Subject" .body = "Bodytext" .To = "" '.CC = Recipient .Attachments.Add "c:\test.xlsx" .Attachments.Add "c:\test2.xlsx" .Send End With FIN: Set olMsg = Nothing Set olApp = Nothing
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Excel Macro update each line based on another worksheet||2||54|
|what is the 64bit version of this window API?||2||23|
|format is changing when i run the find and replace macro||8||23|
|Excel Add-in Subscript out of range||5||28|
Join the community of 500,000 technology professionals and ask your questions.