I want to create a letter that can be sent via email or saved as PDF (or in the worst case exported as csv). The data for the letter comes from the following related objects:

enter image description here

The important object is Session. You enter the sessions the Partner has, with Date from ... to (one day would mean entering the same date twice) and Topic. Topic has a dropdown with three topics z1, z2, z3. There will be many Session items for one Partner.

I want to create a letter that displays the Consultant and his Principal in the header, the Partner in the subject and the details of all related Session entries as conten. The letter should hence look like this:

enter image description here

Unfortunately, I cannot create this via a joined-report, as I will always get all related information in one long line.

How would you solve this problem?

  • Using email template of type Visualforce template may match for your requirement.Are you familiar with visualforce coding? Commented Dec 20, 2012 at 14:14
  • cloudyworlds.blogspot.in/2012/11/… i had blogged also on related requirement like this .May be you may like to look at code and tweak as per your requirement Commented Dec 20, 2012 at 14:21

1 Answer 1


I solved this with a workaround using Microsoft Word's mail merge:

  • Export the data as .xls
  • Use Word's Mail Merge with Catalog / Category (see this topic at SuperUser) to sort the data by category

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .