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.
First of all I would like to say terrific blog! I had a
quick question which I’d like to ask if you don’t
mind. I was interested to know how you center yourself and clear your mind before writing.
I’ve had a tough time clearing my mind in getting my
thoughts out there. I do enjoy writing however it just seems like the first 10
to 15 minutes are usually lost simply just trying to figure out
how to begin. Any suggestions or hints? Appreciate it!
When I initially commented I appear to have clicked on the -Notify
me when new comments are added- checkbox and now each time a comment is added I receive four emails with the exact same comment.
Perhaps there is a means you can remove me from that service?
Thanks!
Hello to every body, it’s my first visit of this web site; this blog consists of
awesome and truly good data in support of visitors.
Saved as a favorite, I like your site!
Here is my site: 918 kiss company
Hey there! Do you know if they make any plugins to assist with SEO?
I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very
good results. If you know of any please share.
Cheers!
Hi there, just became aware of your blog through Google,
and found that it’s truly informative. I’m gonna watch
out for brussels. I will appreciate if you continue this
in future. Lots of people will be benefited from your writing.
Cheers!
Simply desire to say your article is as amazing. The clearness in your post is just spectacular and i could assume you’re
an expert on this subject. Fine with your permission allow me to grab your feed to keep
up to date with forthcoming post. Thanks a million and please carry on the enjoyable work.
Thanks to my father who stated to me concerning this web site,
this webpage is actually remarkable.
I could not resist commenting. Well written!
It’s impressive that you are getting thoughts from this article as well as from our argument made here.
my web blog: ok388 android
wonderful issues altogether, you just received a new reader.
What may you recommend about your post that you made a few days ago?
Any sure?
I blog frequently and I seriously appreciate your
information. This great article has really peaked my interest.
I’m going to book mark your site and keep
checking for new information about once a week.
I opted in for your Feed too.
Pretty nice post. I just stumbled upon your blog and wanted to say that I’ve truly loved browsing your
blog posts. In any case I will be subscribing on your feed and
I’m hoping you write once more soon!
I like the valuable info you supply on your articles.
I will bookmark your weblog and test again here frequently.
I am quite sure I’ll learn many new stuff proper here!
Best of luck for the following!
I got this web page from my pal who told me regarding this site and at the moment this time
I am visiting this web page and reading very informative posts at this place.
I have to thank you for the efforts you’ve put in penning this site.
I’m hoping to check out the same high-grade blog posts from you later on as well.
In fact, your creative writing abilities has inspired me to get my very own site now 😉
A person necessarily lend a hand to make significantly posts I might
state. That is the first time I frequented your web page and so far?
I amazed with the analysis you made to create this particular publish incredible.
Magnificent task!
We stumbled over here from a different web address and thought I might as well check
things out. I like what I see so i am just following you.
Look forward to exploring your web page for
a second time.
Hi there! I know this is kinda off topic but I was
wondering which blog platform are you using for this website?
I’m getting fed up of WordPress because I’ve had problems with hackers and I’m looking at options for another platform.
I would be fantastic if you could point me in the
direction of a good platform.
I love what you guys are up too. This sort of clever work and reporting!
Keep up the very good works guys I’ve included you guys to my personal blogroll.