PRB: Sending Mail With SendObject Contains an Attachment With an Incorrect File Name or File Type.
COMMUNITY SOLUTIONS CONTENT DISCLAIMER
Specifically the attachment contained in Lotus Notes mail Memo, contains an attachment item that has a name similar to "XXXX.xls" where XXXX may be any combination of letters and numbers, even though the SendObject call specified to sent the attachment as in RTF, Snapshot, Text or other file format.
As an example in Visual Basic, your database application makes a SendObject call like the following:
DoCmd.SendObject acSendReport, "My Report", acFormatRTF, "", , , "Sending A Report", "This is the Access Report"
DoCmd.SendObject acSendReport, "My Form", "Snapshot Format (*.snp)", "", , , "Sending A Form", "This is the Access Form"
The resulting Notes mail Memo contains an attachment named "C2B4.xls"
The problem may occur regardless of the Output Format used in the SendObject call.
In a normal situation, during the process where the new mail Memo is created by Lotus Notes, a copy of the intended file attachment is created in the user's temp directory; Lotus Notes then attaches that temporary file to the new mail Memo and then deletes the temporary file from the temp directory.
If for any reason, the creation of the Notes mail Memo fails during this process, the temporary copy of the intended file attachment is left in the user's temp directory as an orphaned file.
If the user then calls SendObject again, with same Report or Form name specified (causing Access to create a file with the same name to use as an attachment ), when Notes attempts to create the temporary copy of the attachment file in the user's temp directory, the old orphaned file of the same name is found. So as to not to overwrite the original (now orphaned) file, a new temporary copy of the attachment file is created, however that temporary file is created with a name in the XXXX.xls format. That temporary .xls file is then attached to the Lotus Notes mail Memo.
The file internally is the correct .rtf, .snp or other format specified in the SendObject call, it is however improperly named in the Note Memo.
On Windows 98 and Me, the temporary directory is commonly located in the path:
On a Windows NT / 2000 / Xp or Server 2003 the temp directory is commonly located in the path:
%System Drive%\Documents and Settings\User Name\Local Settings\Temp
Where %System Drive% is the drive partition on which the operating system is installed, and User Name is the user's log on name.
However, on Windows 2000 and Xp the temp directory is by default a hidden directory. To view the files located in that directory you may have to open Windows Explorer and from the Tools menu item, select "Folder Options" and on the "View" tab, click "Show Hidden Files and Folders".
Then navigate in Explorer to the temp directory and delete any file that has the same name as the file you are expecting to be included as an e-mail attachment.
Article ID: 555020 - Last Review: 12/06/2003 08:50:00 - Revision: 1.0
- kbpubtypecca kbpubmvp kbhowto KB555020