Macro Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello group,
I posted this to excel programming NG and have not recieved a useable
response, so I will try here.
I have a macro that emails a copy of a worksheet to a list of recipients
using .SendMail Recipients:=Array. The macro runs fine on some machines and
will not run on others, all have the same OS (XP Pro), MSO 2003 with like
security settings).The unusual part of it is that typically the macro is
fired by a button or a hot key, however, if I run the macro from the editor,
it runs fine. Has any one seen this before that may could tell me what is
wrong?
Thanks
Sandy
 
Hi Sandy,

do you mean the macro runs manually on every machine, and only the
button doesn´t work?
 
No. The macro runs manually on all machines and runs via the button only on
some machines, that is the problem not running via the button. Sorry for the
confusion.
 
The macro fires and runs by the button up until it gets to the email part.
Thats where is hangs up. If I run it manually it doesnt hang up.
 
Back
Top