We tried uninstalling any office programs, making sure the program files folder was empty and reinstalling the programs. We use Excel 2002 and Outlook 2003. This has worked in the past. I tried logging into my user's PC as myself and ran into the same issue. So it's not profile driven. This is working on other people's PCs with similar setups. Typically a pop-up message from outlook appears letting the user know that another program is trying to send email through it. this does not happen.
Here is the code used in the macro to send the emails.
ActiveWorkbook.SendMail Recipients:="(user's email address)",
Subject:="3420 Report for " & Format(theDate,
"dd-MMM-yy")
Excel macro to send email not running
winfred
Try if the security option is set to Low in the tools--> options . This might cause some error.
I had a similar problem sending mails with Excel 2003, but it worked for Excel 2000. Try if it works with 2000.
If it works with 2000, you might need to include a few lines in your code to make it work with 2002 and 2003
Shasur
Meg!
Here's some info from our support engineer:
Base on my understanding, our buddy met Excel hang on some of the machines once he was trying to send email by VBA. Here are my suggestions:
A) Check CPU usage to see if any of the applications cause the high-CPU
B) Temporarily stop the real-time Antivirus application and try again
C) Do you have any IO operation in your code It may cause the IO dead-lock.
D) Try to send this excel file as the attachment directly in Outlook, any problems happens then
E) Stop Outlook using Word as the default email editor and try again. It will make the problem a little bit simple.
Please let me know your result of above steps and help to gather following information base on the testing on your side:
1) Is the issue Office version related
2) Is this issue OS version related
Anything unclear, please feel free to let me know. Thanks.
-brenda (ISV Buddy Team)