Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
blackcheq
Starting Member
1 Post |
 Posted - 2004-11-05 : 04:00:31
|
| Hi,We are planning to use CDOSYS in SQLServer as our main email sender. Currently, we have sendmail program that utilizes CDOSYS in VB that send emails with file attachments. Most of our attachments are text file format saved in ANSI file type. The problem arises when we have a particular text file attachment that is PIPE(|) delimited and saved in ANSI format. The problem is that the content of the attached text file is being altered especially numbers with decimal places example 100.05 becomes 10005 in the recipients email (it removed the decimal point of the number). when we saved the pipe delimited text file into UNICODE file type (previously saved as ANSI type)the problem does not occur. It is also true when we change the pipe delimiter into tab delimeter there was no problem or changes happening in the text file. Figures or numbers in the text file are vital imformations in text file as this files are being used in our daily process in our company.My question is, is there anyway to prevent the alteration in the file in CDOSYS without changing the file format (using pipe delimiter) or without changing the file type into UNICODE? becuase files are being sent to us by the clients and there's no way for them to change the file format as well as the file type.Note that the alteration only happen when we send attachment thru CDOSYS.Thank you very much in advance for those who will respond to this query! |
|
|
|
|
|
URGENT Help: CDOSYS File Attachment Issue