ActiveWorkbook.SendMail With No Attachment or Can't Open Attachment

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I'm using the following macro on a button on a spread*** to mail
the
workbook to multiple people:

ActiveWorkbook.SendMail Recipients:=Array("u...@xxxxxxx",
"u...@xxxxxxx", "u...@xxxxxxx") Subject:="Production Report",
ReturnReceipt:=False


I have about 19 address in the Array() part. Most people receive the
email with the attached spread***. However, a couple of the
reipients only receive the message with no attachment or they receive
the attachment but cannot open it. When I have them forward the
message to me (the ones with or without an attachment-they claim),
the
attachments are there and I can open them without any trouble. They
tell me that they don't have any trouble opening Excel attachments
from anyone else. I can also see all the attachments. They told me
their macro levels are set to low. It's like the attachment is
there,
but they cannot access it. It is a corporate network using XP/
Exchange/Outlook 2003. I have administrator privelages while I am
not
sure if the people with the problems have it or not. I don't know if
that makes any difference. I just know that most people are getting
it. Is there a different macro to try? Multiple people use this
spread*** on different computers, but it is the shift managers, and
they are not there at the same time of day using the spread*** at
the same time. Any help would be greatly appreciated.


Thanks,


-Chad

.

Quantcast