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.
 
Did you setup the button manually? Maybe you just need to re-create
them.
 
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.
 
Please show us the code and comment where which error occurs.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ThisOutlookSession macro problem 0
Outlook macro for specific email 0
Repetitive mailings-different subjects/attachments 2
Macro won't run 3
Pasting cell contents into a macro 1
Outlook VBA Macro not loading on startup 4
Excel Run macro upon cell edit 0
Macro won't automatically run after a restart 3

Back
Top