Dim olMailItem As Variant
Set out = CreateObject("Outlook.Application")
'strEmail = "firstname.lastname@example.org" 'copy and uncomment these two
'.Recipients.Add strEmail 'lines to add more recipients
strEmail = "email@example.com" 'Sets the recipient string
.Recipients.Add strEmail 'Adds that recipient to the list
.Subject = "New"
.Body = "<\\FILEV02\!GENERAL3\!IT\Logs\" & ActiveWorkbook.Name & ">"
' link to the file; will need to be changed if folder moves or naming scheme changes
' If the path and or filename has spaces, you must enclose the entire path/filename in angle brackets (<>)
At times, a little too much, imho. Don't get me wrong, I think it's great that there's so many ways to do it, depending on what you need, but sometimes it's hard to look at all of that and know right off the bat. Or is it just me? ray: (Chanting: We're not worthy! We're not worthy!")
No, I don't believe so. Like both solutions provided above, the one I will give is code that uses outlook, but it must be open for the mail to go out. You can make this 'invisible', but I don't think you can use Outlook to send something if it is not open. I could be wrong.
Btw, if using Outlook and this will be used by multiple users and/or multiple versions, I suggest using Late Binding. Do some reading on it, a board search will wield decent results. DK talks about it a lot.