April 12, 2005 at 9:59 am
Hi dear friends,
I'm using a DTS Package with 1 Sendmail Task. This Sendmail Task sends a message with 1 attachment. I'd test it using my personal mail account (with MS Outlook 2000). The attachment's original path is C:\ruta1\datos\archivo.txt, but when I sent it to a external (yahoo for example) mail, the attachment's name changes to C_ruta1_datos_archivo.txt.
Anybody knows how must I do for the attachment's name remains like "archivo.txt"?? (when I review my "Sen Items" folder the attachemnt's name is "archivo.txt")
Thanks for any help...
Regards,
Jorge
April 13, 2005 at 6:43 am
When you send an attachment in an email it is converted to encoded (encrypted really) text that is added to the bottom of the email. When it arrives on another email system you dont see the encoded text when you look at or edit the email, you just see an icon to indicate that there is an attachment. It is only when you open the attachment that the text gets un-encoded and saved to a file. The name of the temporary file that is created is specified in the options for the email program you are using to view the attachment. Different email programs will create an attachment file with different names.
When an attachment is added to an email you can change the name that appears on the email 'attachment' icon, but the original file name (and path) is also stored as a property.
If you don't like the name given to the attachment in Yahoo mail, either use a different email program to view the attachment, or move the file to the c:\ (root) folder before you attach it to the email (but this will still give you C_.. at the front of the name). I don't know Yahoo mail, but check if there is an option to change the name of the temprorary file created.
Anyway, if you save the attachment rather than opening it, it should give the file created the same name as the display name of the attachment in the email.
Peter
April 13, 2005 at 8:11 am
Peter, thanks for your suggestions... But i'm not quite sure it works as you said...When I manually sends mails (with attach files) using MS Outlook it works fine: at destination arrives with the same name as I sent!!..... The problem only happens when I send mails (with attach file) using a DTS Sendmail task.
What could be happening?... thanks for any help!
Jorge
April 13, 2005 at 8:14 am
....I'm using SendMail task with a MS Outlook profile (for your information)
Thanks & Regards
Jorge
April 13, 2005 at 8:41 am
I have just send an attachment from a DTS Sendmail task (in MSSQL 2000) using MS Outlook 2002 (on windows XP).
In the sent items folder it shows the attachment with the correct name. I sent the email to myself and when it arrived in Outlook the attachment still had the correct name.
When you sent the email to your Yahoo mail account, did the attachment have the correct name in the sent items folder in Outlook. If it did, then the problem may be that Outlook is not saving the original file path with the attachment, but the Sendmail task is saving the path.
Check if you can change the options in Yahoo mail to not use the attachment's original path in the file name when it opens or saves the attachment.
Peter
April 14, 2005 at 1:23 pm
Have you tried using xpsmtp80.dll to send smtp mail, there is a good link below with code examples
http://www.sqldev.net/xp/XPSMTP.htm
Martin
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply