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.
Every weekend i used to pay a visit this site, as i wish for enjoyment, as this this web site conations actually fastidious funny data too.
I l᧐ved as much as you will receive carried
out right here. Tһe sketch іs tasteful, yoսr authored material
stylish. nonetheless, you cοmmand get bought an edginess over that you
wish be delivering the foⅼlowing. unwell unquestionably come further formerⅼy again since exactly the same nearly very often inside case you
shielkd thiѕ hike. http://www.coolen-pluijm.nl//cookies/?url=https://www.ptc.nsw.edu.au/community/profile/hithinyyyt/
Thank you for some other informative site. Where else may just I am getting that kind
of info written in such a perfect method? I have a mission that I am just now
operating on, and I have been at the look out for such information.
Spot on with this write-up, I really think
this site needs far more attention. I’ll probably be back
again to see more, thanks for the information!
Helpful info. Lucky me I discovered your website unintentionally, and
I’m stunned why this coincidence did not came about earlier!
I bookmarked it.
Good day! Would you mind if I share your blog with my twitter group?
There’s a lot of folks that I think would really appreciate your content.
Please let me know. Cheers
My site: greatwall99 for ios [918kiss-m.com]
Hey just wanted to give you a brief heads up and let you
know a few of the images aren’t loading properly.
I’m not sure why but I think its a linking issue.
I’ve tried it in two different browsers and both show the
same outcome.
Feel free to surf to my webpage playboy2apk android
Hello, all is going perfectly here and ofcourse every one is
sharing data, that’s really good, keep up writing.
my web blog; pussy888 pc
I do not even know how I ended up here, but I thought this
post was good. I don’t know who you are but definitely you
are going to a famous blogger if you aren’t already 😉 Cheers!
Feel free to visit my webpage :: 918kiss welcome bonus 100
Very descriptive post, I liked that a lot. Will there be a part 2?
Hi, i think that i saw you visited my website thus i
came to “return the favor”.I’m trying to find things to improve my
website!I suppose its ok to use a few of your ideas!!
Also visit my web page: joker123 pc download
Thanks a lot for sharing this with all people you actually
recognise what you are speaking approximately! Bookmarked.
Kindly additionally talk over with my site =). We could have a hyperlink change arrangement between us
Also visit my homepage; akaun test king855
Thank you a lot for sharing this with all people you actually know what you’re talking about!
Bookmarked. Please also discuss with my web site =).
We could have a link exchange contract between us
Feel free to surf to my blog post … slot sky777
Hi there, just became aware of your blog through Google, and found that it’s
truly informative. I’m going to watch out for brussels.
I’ll appreciate if you continue this in future. Many people will be benefited from your writing.
Cheers!
Here is my web-site; Live22 Download Apk
I enjoy reading through an article that will make men and women think.
Also, thank you for allowing me to comment!
Feel free to visit my web site; calibet
We are a group of volunteers and starting a new scheme in our community.
Your website provided us with valuable information to work on. You’ve
performed a formidable task and our whole neighborhood will be grateful to you.
Also visit my page – aaa1188 free download
It’s a shame you don’t have a donate button! I’d definitely
donate to this fantastic blog! I suppose for now i’ll settle for bookmarking and adding your RSS feed to my Google account.
I look forward to brand new updates and will share this blog with my Facebook group.
Chat soon!
You could definitely see your skills in the work you write.
The sector hopes for more passionate writers like you who aren’t afraid to
mention how they believe. At all times go after your heart.
Here is my web-site: jom kiss918
I am curious to find out what blog system you happen to be working with?
I’m experiencing some small security issues with my latest blog and
I would like to find something more secure. Do you have any recommendations?
my website … sgbet99
Wow! In the end I got a website from where I know how to truly
obtain valuable data concerning my study and knowledge.
Check out my blog post: kiss918 download ios