Tell me more ×
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It's 100% free, no registration required.
up vote 2 down vote favorite

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?

share|improve this question
Using email template of type Visualforce template may match for your requirement.Are you familiar with visualforce coding? – Mohith Kumar Dec 20 '12 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 – Mohith Kumar Dec 20 '12 at 14:21

1 Answer

up vote 1 down vote accepted

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
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.