I am querying some fields of Account objects records. And i am storing them in a list. Now i want to send this data through mail with excel sheet attached(which contains list data of Account Records) on click of send email from VF page. But i am getting the error as blob variable do not exist. Please check the below code.
List<Account> ObjectList1 = [SELECT id,Name FROM Account];
Messaging.EmailFileAttachment csvAttc = new Messaging.EmailFileAttachment();
blob csvBlob = Blob.valueOf(ObjectList1);
string csvname= 'Duplicate.xls';
csvAttc.setFileName(csvname);
csvAttc.setBody(csvBlob);
Messaging.SingleEmailMessage email =new Messaging.SingleEmailMessage();
String toAddresses = '[email protected]';
String subject ='Duplicate Data';
email.setSubject(subject);
email.setToAddresses( toAddresses );
email.setPlainTextBody('Duplicate Data');
email.setFileAttachments(new Messaging.EmailFileAttachment[]{csvAttc});
Messaging.SendEmailResult [] r = Messaging.sendEmail(new Messaging.SingleEmailMessage[] {email});