Text files not attaching to email correctly

**MikeFranz123** · 03-31-2014, 06:31 AM

Hi,

I'm trying to send a few emails with some .txt files attached. It is sending the emails, along with text files, but the data within the text files are either missing or giving me weird Chinese symbols.

Here is the code:

Please Login or Register  to view this content.

As I said, the email is sending no problem, with files attached, but the data within the files are corrupted. I've checked, and the links are referencing the correct files.

Any ideas would be awesome!

Thanks

Mike

**Olly** · 03-31-2014, 07:23 AM

It sounds like the text encoding of the text files is inconsistent, rather than it being the above code to attach the files to an email.

How are the text files generated? Have you tried changing the encoding when you open the text file?

**MikeFranz123** · 03-31-2014, 08:22 AM

Hi, thanks for the reply. I generate them through some R code. I haven't tried changing the encoding, how would I do that?

**Olly** · 03-31-2014, 08:29 AM

Some R code? What is R code?

**MikeFranz123** · 03-31-2014, 08:41 AM

Its another programming language. I read some data in through Excel, pass it over to R which does the calcs (and generates the text files) and then passes it back to Excel, where I would like to now send the email.

**Olly** · 03-31-2014, 08:50 AM

So, what happens if you open those text files immediately after R creates them before Excel does anything to them? Do they parse okay, or is the encoding still not right? If it's encoded wrong by the R routine, you have found your problem, and it's nothing to do with Excel!

Feel free to attach one of the text files, I can check the encoding for you.