Net Send

[ericthered]

I am trying to send a message over the network from excel, where the recipients name would be in a cell (or a list box), and the message to send was in a different cell.

I thought of using the net send via the dos command prompt eg net send computer.name message.to.send

Is this the best way? Can anyone help?

I am just starting out with VBA so any answers would need to be an idiots guide !!

Thanx

[mangesh_yadav]

try following code

Private Sub CommandButton1_Click()

RetVal = Shell("net send " & Range("A1") & " " & Range("B1"))

End Sub


where A1 has computer name, and B1 has the message

Mangesh

[ericthered]

Mangesh,

Superb, thank you very much.

(I have been away for a few days so only got to try it today).

Many Thanks again

EricTheRed