Hi All,

I have got this to work myself and used in my project. Here is the sample code.

************* VF Component *******************(Component Name say : testemail)

<apex:component controller="emailattachment" access="global">

<apex:attribute name="emailatt" description="Attachment URL" access="global" type="String" assignTo="{!Oppid}"/>

<apex:repeat value="{!attach}" var="att">
<a href="{!att}">{!attach[att]} </a> <br/>
</apex:repeat>

</apex:component>

*********************************************************

******************** Component Controller Class *********************************

public class emailattachment {

public string Oppid;
public string attid;
public Map<String,String> urlMap=new Map<String,String>();
public List<Attachment> attach;

public string getOppid() {
return null;
}

public void setOppid(String s) {
Oppid=s;
}

public Map<String,String> getattach() {
attach=[Select id,name From Attachment Where Parentid=:Oppid];

for(Attachment att1:attach) {
String urls=URL.getSalesforceBaseURL().toExternalForm()+'/servlet/servlet.FileDownload?file='+att1.id ;
urlMap.put(urls,att1.Name);
}
return urlMap;
}

public void setattach(List<Attachment> ata) {
attach=ata;
}

}

***********************************************************************************

****************VF Email Template*********************************

<messaging:emailTemplate subject="Email Subject" recipientType="User" relatedToType="Opportunity">

<messaging:htmlEmailBody >

// Body of your email

// Below is the link to the attachments associated with the opportunity record

<c:testemail emailatt="{!relatedTo.id}" rendered="true">
</c:testemail>

</messaging:htmlEmailBody> 

</messaging:emailTemplate>

*************************************************************************

First create the VF component and custom controller for it. and then include the component in the vf email to get the link to the associated attachments. Note that, with this approach users will be required to login to salesforce to access the files.

Please mark it as a Solution if it answers your question.

Thanks,

Koushik