Skip to main content

Sending CSV attachment in Mail and Downloading in CSV Format

Hi All, 

 This post is all about sending CSV attachment and downloading in CSV format. Below is the page having list of accounts records in a table and button "Send", when clicked it will send a mail to user email id containing attachment of list Of accounts. Also download Results link to download contacts of corresponding account.

 Here the main page code -
<apex:page controller="CSVAttachmentANDDownload">

     <apex:form >
        <apex:pageBlock >
            <apex:pageBlockTable value="{!accountList}" var="account">
                <apex:column value="{!account.id}"/>
                <apex:column value="{!account.Name}"/>
                <apex:column value="{!account.Phone}"/>
                <apex:column headerValue="Action" >
                    <apex:commandLink action="{!ResultsDownLoad}" style="color:green;">
                        <apex:param value="{!account.id}" name="accountid"/>
                        <apex:outputText value="Download Results" />
                    </apex:commandLink>
                </apex:column>
                
            </apex:pageBlockTable>
            <apex:commandButton value="Send" action="{!sendingCSVAsAttachement}"/>
        </apex:pageBlock>
    </apex:form>

</apex:page>

 Here is controller -
public class CSVAttachmentANDDownload{
    
    public list<Account> accountList{get;set;}
    public list<Contact>Contacts {get;set;}
    public CSVAttachmentANDDownload(){
        accountList = [select id,Name,Phone from Account Limit 10];
    }
    
    public void sendingCSVAsAttachement(){
    
        OrgWideEmailAddress[] owea = [select Id from OrgWideEmailAddress where Address = 'no-reply@brocade.com'];
    Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage();
          String[] toAddresses = new String[] {Userinfo.getUserEmail()};
          mail.setToAddresses(toAddresses);
          mail.setSubject('Account Upload Results');
          
          if ( owea.size() > 0 ) {
                mail.setOrgWideEmailAddressId(owea.get(0).Id);
            }
           
            String body;
            body = '<html lang="ja" style="font-family:Calibri"><body>'+ '<br>'+
                        'Hi '+UserInfo.getName()+','+
                          '<br><br>'+'Please find enclosed accountlist'+'<br><br>'+
                          'Thank you,'+'<br/><br/>'+
                          'Salesforce'+'<br/>'+
                          '</body></html>';
                          
           mail.setHtmlBody(body);
            //List<dataWrapper> lstDataWrap = createDataWraps();
            List<String> headerFields = new List<String>{'Acountid','Account Name','Phone'};
            
            String csvString = ''; 
            for(String header : headerFields)
            {
                csvString = csvString + ',' + header.replace(',','');
            } 
            csvString = csvString.replaceFirst(',','') + '\n';
            String fileRow = '';
            String fieldValue = '';
            for(Account acc : accountList )
            {
                String data = acc.Id+ ',' + acc.Name+',' + acc.Phone;
                csvString = csvString + data + '\n';
            }
            Blob csvBlob = Blob.valueOf(csvString);   //Convert the data to Blob format
             
            Messaging.EmailFileAttachment efa = new Messaging.EmailFileAttachment();
            efa.setFileName('AccountResult.csv');  //Set the name of the file
            efa.setBody(csvBlob);        
            mail.setFileAttachments(new Messaging.EmailFileAttachment[] {efa}); 
             Messaging.sendEmail(new Messaging.SingleEmailMessage[] { mail });
          
    }
    
    public PageReference ResultsDownLoad(){
        Id accountid;
        accountid = Apexpages.currentPage().getParameters().get('accountid');
        Contacts = [SELECT id,Name,FirstName,Lastname,Phone,Title from contact where accountid =:accountid ];
        return Page.CSVDownLoad1;
    }

}
if clicked on download result link contacts of corresponding account will be download in CSV format.
For this CSV download, there is another page(CSVDownLoad1) designed for it.
<apex:page controller="CSVAttachmentANDDownload" contentType="text/csv#Contact.csv">"Title","First Name","Last Name"
     <apex:repeat value="{!Contacts}" var="con" >
     {!con.Title},"{!con.FirstName}","{!con.LastName}"
     </apex:repeat>
</apex:page>


If you come across any issue on same, please feel free to comments or mail to asish162@gmail.com



















Labels:






































Comments








Post a Comment
























Popular posts from this blog





















How to Create a Tooltip in Lightning Datatable ?




























Imagine you have a datatable  displaying a list of Contact records , and one of the columns shows the Account Name . The Account Name  is a hyperlink that allows users to navigate to the Account record page. But what if users want to take a quick glance at some key Account fields —like Phone or Address—without navigating to the Account record? In Salesforce Classic, this was achieved using the Mini Page Layout  feature from standard page. However, in Lightning Experience, we can implement a similar feature by adding a tooltip  to the data table. Solution Overview: We’ll create a Lightning Web Component (LWC)  that: Displays a data table with a clickable Account Name . Provides a tooltip  that shows the Account's Phone  and Address  fields when users hover over the Account Name. Implementation Steps: 1. Data Preparation We need to retrieve the following fields for each Contact and its associated Account: Contact Fields : Name, Phone, Email Account Fields : Name, Phone, Billing Addre...




















Post a Comment









Read more




























📆 How to Get the Start and End Date of the Previous Quarter in Apex ?




























 When working with Salesforce data, it's often necessary to filter or report on records from a specific quarter . If you're looking to retrieve the start and end dates of the previous quarter  based on the current date, here’s a simple and reusable Apex utility you can use. 🔧 Apex Utility Methods Below are two helper methods:     getStartDate()  — Calculates the start date of the previous quarter .    getEndDate()  — Calculates the end date of the previous quarter , based on the start date. // Helper method to get the start date of the previous quarter private Date  getStartDate ()  {     Date  today =  Date . today ();     Integer  currentYear =  today . year ();     Integer  currentMonth =  today . month ();     // Determine the first month of the previous quarter     Integer  previousQuarterStartMonth =  (( currentMonth -  1 )  /  3 )  *  3  +  1  -  3 ;     // Adjust the year if the previous quarter falls in the previ...




















Post a Comment









Read more






























Add/Remove Functionality in a VF page for Creating Multiple Records For a Particular Object.




























 Hi Guys  This is a very simple post. I had come across a scenario where I was asked to develop some functionality where user can create list of records at a time(clicking on save button on one time) and can remove row.   Here I have created a pageblock table and there I am displaying 5 rows to enter data and there column, Name , Phone and Action. In Action column Delete link is present.When that link(Delete) is clicked then particular row will be removed. Two button is there Add Row and Save.   Add Row-->  When that button is clicked one more row will be created in the pagablock table   Save--> It will save the record.   Here is the page    <apex:page controller="creatingListOfRecordsController">       <apex:form >                  <apex:pageBlock title="Creating List Of Account Records">           <apex:pageMessages></apex:pageMessages>               ...




















13 comments









Read more