corrupted file when the xlsx is sent through google

ggreen86 / XLSX-Workbook-Class

VFP Class to Create an XLSX Workbook without Excel Automation or Installed

45 stars 16 forks source link

corrupted file when the xlsx is sent through google #85

Closed Ajitweb closed 1 year ago

Ajitweb commented 1 year ago

Obviously, nothing is wrong with the workbook class - because I can open the created file - locally. But when I attach that file in gmail and send it, the recipients cannot open the excel file - it says that the file is corrupted.

Anybody has encountered this ?

Ajitweb commented 1 year ago

Apparently, this happens because google wants the body of the email to be filled with something. I am using CDO2000 to send emails and I filled its cTextBody property with some dummy text - and now the attachments are openable! Dont know why an empty body is creating corrupted attachments.