How to create an excel reminder to Outlook? is it possible?

' in ThisWorkbook as Workbook AfterSave:

Private Sub Workbook_AfterSave(ByVal Success As Boolean)

Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String

Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)

strbody = "Hi there" & vbNewLine & vbNewLine & _
"This is line 1" & vbNewLine & _
"This is line 2" & vbNewLine & _
"This is line 3" & vbNewLine & _
"This is line 4"

On Error Resume Next
With OutMail
.To = "[email protected]"
.CC = ""
.BCC = ""
.Subject = "This is the Subject line"
.Body = strbody
'You can add a file like this:
'.Attachments.Add ("C:\test.txt")
.Send 'or use .Display
End With
On Error GoTo 0

Set OutMail = Nothing
Set OutApp = Nothing

End Sub

Im completly impressed, just like that . Thanks a lot! Now what Ill try to do is that the mail tels you where the file that has been changed is and what changes happened to that file.
See if I can do it, otherwise, I think Ill write another post .
Thanks a lot though for your help, thanks so so much!

Well, you could always try this solution:



Body text:

strbody = "Changes (and might be placement of file) of the file " & ThisWorkbook.FullName & " by user " & Application.UserName & " was saved " & Now() & vbNewLine & vbNewLine & _
"See attached file..."

And under email:

With OutMail
.To = "[email protected]"
.CC = ""
.BCC = ""
.Subject = "Excel file was just saved..."
.Body = strbody
.Attachments.Add (ThisWorkbook.FullName)
.Send
End With

Understood, sorry and thanks

but this automatically gets updated depending on the user who saves the file as well as if for example someone changes the file of location?

This is correct, but you should be able to change any setting from this example to what you actually do want. :o)

wooow! man! crazy! honestly, gotta learn all about macros, can sole a lot of problems! thanks a lot!

Hallo, myself again, I have a queston regarding that macro, is there any command that you know please, which stops the person whi changes the file recieving an email? This means that when Im the one who recieves the mail everytime something in the file is changed , is there a way to stop recieving a mail when it is me, myself,the one who changes the file? dont know if iI make myself very clear..
Thanks once more!

That's a different question, please start a new thread

Sorry but I beg to differ, the question is completly related to my previous post as it specifically affects one little part of the macro we are discusing, starting a new post would be completly redudant as would require , most likely, whoever answered it to rewrite the same or very similar macro.
Moreover my previous question on this same macro -about how could be set the macro so it stated in the mail sent who made the changes in the file- was of the same nature of the one you state now that needs a new thread, with the slight diference that before I wasnt require by you to do so.
Regards

Your question isn't about outlook, it's about finding out who the active user is when saving a workbook, the outlook part is unrelated.

Part of the forum is helping other users, as such someone searching for how to identify the active user and behave accordingly is likely to search for that rather than creating outlook reminders.