String csvHeader = 'AccountId, Latest Opp \n';
string mainContent = csvHeader;
Map opps = new Map();
for(Opportunity op: [select AccountId, Billing_Frequency__c,Customer_Type__c , closedate from Opportunity where closedate >2019-03-01 and closedate <2020-03-31 and StageName='Closed Won' order by closedate asc]){
opps.put(op.AccountId, op);
}
for (Id oid : opps.keySet()) {
mainContent+= oid+','+opps.get(oid).Id+'\n';
}
Messaging.SingleEmailMessage singEmail = new Messaging.SingleEmailMessage ();
String [] toAddresses = new list {'ayub.salsforce@gmail.com'};
//Set recipient list
singEmail.setToAddresses (toAddresses);
String subject = 'Retroactively Created Agreements';
singEmail.setSubject (subject);
singEmail.setPlainTextBody (mainContent);
Messaging.SendEmailResult [] r = Messaging.sendEmail (new Messaging.SingleEmailMessage [] {singEmail});
175 thoughts on “Generate CSV using apex and email as attachment”
Comments are closed.
What i do not realize is if truth be told how
you are no longer actually much more neatly-liked than you might be right now.
You are very intelligent. You recognize therefore significantly when it
comes to this subject, made me personally believe it
from numerous various angles. Its like women and men aren’t interested unless it’s
one thing to accomplish with Girl gaga! Your individual stuffs
outstanding. All the time handle it up!
I was wondering if you ever considered changing the page layout of your website?
Its very well written; I love what youve got to
say. But maybe you could a little more in the way of content so people could
connect with it better. Youve got an awful lot of text for only having one or two pictures.
Maybe you could space it out better?
my homepage – game joker888
I absolutely love your blog.. Pleasant colors & theme.
Did you develop this amazing site yourself? Please reply back as
I’m attempting to create my very own website and would like to learn where you got this from or what the theme is named.
Many thanks!
I think the admin of this web site is truly working hard
for his web site, because here every stuff is quality based data.
Hello, I enjoy reading all of your article post. I wanted to write a little comment to support you.
If some one desires expert view concerning blogging then i suggest him/her to visit this
web site, Keep up the pleasant job.
Thanks for finally talking about > Generate CSV using apex and email
as attachment – SFDCians < Loved it!
Do you have a spam issue on this blog; I also am a blogger, and I
was wondering your situation; many of us have created
some nice procedures and we are looking to trade strategies with others,
be sure to shoot me an e-mail if interested.
Hi there, You’ve done a great job. I’ll certainly digg it and personally suggest to my friends.
I am confident they’ll be benefited from this website.
Have you ever considered publishing an ebook or guest authoring on other websites?
I have a blog based on the same subjects you discuss and
would really like to have you share some stories/information. I
know my viewers would appreciate your work. If you’re even remotely
interested, feel free to shoot me an e mail.
Howdy! I could have sworn I’ve been to this website before but after reading
through some of the post I realized it’s new to me.
Nonetheless, I’m definitely glad I found it and I’ll be book-marking and checking back often!
What a stuff of un-ambiguity and preserveness of precious experience concerning
unexpected feelings.
I really enjoy looking through on this site, it has great
content.
My web site :: shaboxes.com
This post presents clear idea designed for the new users of blogging, that really how to do
blogging.
Pretty component of content. I simply stumbled upon your website and
in accession capital to assert that I get actually loved
account your weblog posts. Anyway I will be
subscribing to your feeds and even I fulfillment you get admission to
consistently quickly.
I just like the valuable info you provide on your articles.
I’ll bookmark your blog and test once more here frequently.
I’m quite sure I’ll learn a lot of new stuff proper here!
Best of luck for the following!
When someone writes an post he/she retains the image of a user
in his/her brain that how a user can understand
it. So that’s why this piece of writing is perfect.
Thanks!
Excellent pieces. Keep posting such kind of info on your site.
Im really impressed by it.
Hello there, You have performed an incredible job.
I’ll definitely digg it and in my opinion suggest to my friends.
I am confident they will be benefited from this website.
If you would like to increase your knowledge just
keep visiting this web site and be updated with the most up-to-date news posted here.
Thank you for every other informative web site. The place else may just I am getting that kind
of info written in such a perfect manner? I’ve a challenge that I
am just now working on, and I’ve been at the look out for such
info.