I've searched for this problem in the newsgroups and found several
posts but not a solution. I have a spreadsheet set up with a macro
that emails a list of people a copy of the spreadsheet. Everyone gets
the email in their Outlook, but a couple of the people get the
message, but there is no attachment to click on and open. The email
message is the right size, but there is nothing to click on. If I
attach a 150K excel sheet, the message is about that size with nothing
to click on. If these people forward the message to me, the
attachment is there, and I can open it. However, they do not see the
attachment before they hit send. All the users are using Outlook 2003
on an exchange server. The Excel sheet contains a macro, so I don't
know if this is a security or formatting problem. Any help would be
greatly appreciated.

Thanks,

-Chad

On Mar 28, 9:44 am, wrote:
I've searched for this problem in the newsgroups and found several
posts but not a solution. I have a spreadsheet set up with a macro
that emails a list of people a copy of the spreadsheet. Everyone gets
the email in their Outlook, but a couple of the people get the
message, but there is no attachment to click on and open. The email
message is the right size, but there is nothing to click on. If I
attach a 150K excel sheet, the message is about that size with nothing
to click on. If these people forward the message to me, the
attachment is there, and I can open it. However, they do not see the
attachment before they hit send. All the users are using Outlook 2003
on an exchange server. The Excel sheet contains a macro, so I don't
know if this is a security or formatting problem. Any help would be
greatly appreciated.

Thanks,

-Chad


I figured out what the problem was. FYI to anyone that sees this
problem:

The problem was that Outlook has a hidden folder that it uses for
temporary attachment storage. I found that Outlook has trouble when
there are 100 temporary files with the same name. Since we always
send out the files with the same name, it keeps creating temporary
files with the same name:

When Outlook gets to 100 files in the temporary file folder with the
same name, your attachments with that name will become invisible, and
you will get the following error when you try to save or open the
"invisible" attachment:

Can't create file: Production Shift Report.xls. Right-Click the folder
you want to create the file in, and then click Properties on the
shortcut menu to check your permissions on the folder.

This is basically saying you have too many temporary files with that
name, and you cannot open any other files with this name. Once you
clean out these files in the Outlook temporary folder, the attachments
should appear, and you should be able to open and save these
attachments.

The folder is located
C:\Documents and Settings\user\Local Settings\Temporary Internet Files
\OLK**

The last 2 characters in the OLK** are random, and you will either
need to open an attachment and finding the file location in the
properties or search the registry for the OutlookSecureTempFolder key.

I didn't figure this out on my own but pieced it together from other
newsgroup posts.

Thanks,

-Chad

wrote:

I figured out what the problem was. FYI to anyone that sees this
problem:

The problem was that Outlook has a hidden folder that it uses for
temporary attachment storage. I found that Outlook has trouble when
there are 100 temporary files with the same name. Since we always
send out the files with the same name, it keeps creating temporary
files with the same name:

Well known issue that has been discussed many, many times in this newsgroup.
See
http://www.howto-outlook.com/faq/securetemp.htm
--
Brian Tillman