Underscores in attachment file name

R

Robert Priestley

Hi,

If I send an email from a DTS sendmail task with an attachment (say
C:\files\MyAttachment.txt) and then receive this email in outlook express
(6), the attachment file name is displayed as C__files_MyAttachment.txt.

If I send the same mail again, only this time receive it in Outlook (2003)
the attachment name is displayed correctly as MyAttachment.txt

The attachments can be saved OK, however, the difference is when using
Outlook express the attachment MUST be saved using "Saved as", forcing the
user to rename the file back to MyAttachment.txt, whereas in Outlook they
can use save and just selected a destination folder without having to
rename.

Anyone any ideas why this is?.

Many thanks.

Rob.
 
R

Robert Priestley

Update:

It seems as tho the the DTS SendMail task always sets the name of the
attachment to its full path name and there is no way to get around this.
Outlook seems clever enough to strip out the path and display the correct
file name when it receives the email, whereas Outlook Express 6 is not, it
displays the full path name replacing unrecognised chars with underscores.

Rob.
 
R

Robert Priestley

Update number 2.

Actually, there is a solution. Use the SQL server extended stored procedure
xp_SendMail defined in the master DB.

This sends attachments correctly without adding the whole path name.

Rob.
 
Top