Hi 

make a page  to which to want send as attachment

<apex:page controller="ExcelsheetVfController" renderAs="pdf">

In this controller ExcelsheetVfController please write the logic for whatever value you want to send .

make anthoer page and controller from where you want to send mail ...In taht controller write all the logice for sending mail with attachment. Here is some you can follow .This is code tro send mail to user of contact object.Attachment is a perticular Quote detail .

public PageReference attachpdf()
{
Id quoteid = ApexPages.currentPage().getParameters().get('quoteid');
//cid----- means a contactId
Id cid = ApexPages.currentPage().getParameters().get('cid');
quote1 = [select id,name from Quote where id =:quoteid];
PageReference pdfPage = Page.pdfPage;
pdfPage.getParameters().put('id',quoteid);
Blob pdfBlob = pdfPage.getContent();
Attachment a = new Attachment(parentId = quote1.id, name=quote1.name + '.pdf', body = pdfBlob);
insert a;
PageReference nextpage = new PageReference('/apex/convertpdf?cid='+cid+'"eid='+quoteid);
ApexPages.addMessage(new ApexPages.message(ApexPages.severity.INFO,'PDF Attached Successfully'));
return nextpage;
}
public pageReference SendEmail()
{
Id quoteid = ApexPages.currentPage().getParameters().get('quoteid');
Id cid = ApexPages.currentPage().getParameters().get('cid');
for (String obj : selectedNames)
{
contact = [select Id,name,email from Contact where name =:obj];
System.debug('##########Mail###############'+contact.size());
for(Integer i=0; i < contact.size(); i++)
{
quote1 = [select id,name from Quote where id =:quoteid];
Messaging.SingleEmailMessage email = new Messaging.SingleEmailMessage();
List<Messaging.Emailfileattachment> fileAttachments = new List<Messaging.Emailfileattachment>();
for (Attachment a : [select Name, Body, BodyLength from Attachment where ParentId = :quoteid])
{
Messaging.Emailfileattachment efa = new Messaging.Emailfileattachment();
efa.setFileName(a.Name);
efa.setBody(a.Body);
fileAttachments.add(efa);
}
email.setFileAttachments(fileAttachments);
email.setTargetObjectId(contact[i].Id);
email.setTemplateId(e1.id);
Messaging.sendEmail(new Messaging.SingleEmailMessage[] { email });
}
}
PageReference nextpage = new PageReference('/apex/convertpdf?quoteid='+quoteid+'&cid='+cid);
ApexPages.addMessage(new ApexPages.message(ApexPages.severity.INFO,'Email Sent Successfully'));
return nextpage;
}

I think It will help you..

Did this answer solve your problem ... If so please mark it solved

Thanks

asish