Hi all

I have written a routine (see below) to create an email from the clients
machine
This is triggered when the contents of a specific cell is changed

It works well except that I would like it to send it "behind the scene"
without giving the client the option of not sending it!

I don't know whether this is possible . . .

Sub SendEmail()
Dim AddressString As String

AddressString = "mailto:" & " & "?subject=" _
& "This is the subject" & "&body=" & "This is in the body"

ThisWorkbook.FollowHyperlink Address:=AddressString

End Sub

Is there some code that I can insert that will go on to put it, preferably
hidden (like a read receipt), in the outbox automatically?

Thanks, in anticipation
Peter Bircher

www.automatexcel.co.za