how to attach notes and attachments from opportunity to my visual force email template

Hi,

Can someone guide me how to include attachments from Opportunity page into my visual force email template.

I am doing something like this ....

<messaging:emailTemplate subject="There is no subject" recipientType="Contact" relatedToType="Opportunity">
<messaging:htmlEmailBody >

<messaging:attachment renderAs="pdf" filename="test.pdf">

<apex:repeat value="{!relatedTo.Attachments}" var="na">

{!na.body}

</apex:repeat>

I get some error ...

Error: ; nested exception is: common.exception.ApiException: Binary fields cannot be selected in join queries

Thanks in advance

Chirag Mehta
Were you able to solve this issue? (there are workarounds, but I want to see if there's a direct solution or not).

Niket
Hi Chirag ,

Could you please share a work around ? I am also facing the same issue.

Thanks in advance for your help.

Need an account? Sign Up

Have an account? Sign In