LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default ActiveWorkbook.SendMail With No Attachment or Can't Open Attachment

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

ActiveWorkbook.SendMail ",
", ") Subject:="Production Report",
ReturnReceipt:=False

I have about 19 address in the Array() part. Most people receive the
email with the attached spreadsheet. 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
spreadsheet on different computers, but it is the shift managers, and
they are not there at the same time of day using the spreadsheet at
the same time. Any help would be greatly appreciated.

Thanks,

-Chad

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
unable to open excel attachment, download won't open N. Joel Salzburg New Users to Excel 2 October 28th 08 01:21 PM
Email attachment when someone else has it open nockam[_3_] Excel Programming 2 January 25th 06 02:36 PM
cannot open excel file from as attachment Pegasus Excel Discussion (Misc queries) 1 January 16th 06 07:52 PM
how do i open an attachment created by excel? paulae63 Excel Discussion (Misc queries) 2 June 17th 05 01:29 PM
++++++++++ Cannot open .CSV attachment Ian Excel Discussion (Misc queries) 2 December 9th 04 10:37 PM


All times are GMT +1. The time now is 03:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"