W
wannavrapter
I have used the following code with a button on an Excel form which I
have mailed to certain users in the company. We are all using XP with
windows 2000 to 2002 sp2 (consistantcy is marvellous).The company does
not use exchange server so we just have out look
When I test the form in one location it works fine. However a user at
another location is having trouble with the form and gets the following
error message:-
Run-time error `1004'
Method `sendmail' of object -workbook faild.
I have checked their macro security settings and have no idea what is
causing this . Any ideas it must be some setting within Excel.??
Private Sub cmdmailedc_Click()
ActiveWorkbook.sendMail Recipients:=Array("(e-mail address removed)",
"(e-mail address removed)")
End Sub
***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
have mailed to certain users in the company. We are all using XP with
windows 2000 to 2002 sp2 (consistantcy is marvellous).The company does
not use exchange server so we just have out look
When I test the form in one location it works fine. However a user at
another location is having trouble with the form and gets the following
error message:-
Run-time error `1004'
Method `sendmail' of object -workbook faild.
I have checked their macro security settings and have no idea what is
causing this . Any ideas it must be some setting within Excel.??
Private Sub cmdmailedc_Click()
ActiveWorkbook.sendMail Recipients:=Array("(e-mail address removed)",
"(e-mail address removed)")
End Sub
***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****