I have a list, the user adds items to the list, as and when the items added to the list, should be exported to an excel sheet. Then needs to send an email to "Assigned To" person along with that excel sheet. is this possible? Please guide me.
I understand that you want to export list items to excel and send this excel as attachment to the Assigned To person .If you want to do this without code ,you need to manually export the list to excel .
Open the list in browser .Click List>Export to Excel .
Add a filter on the Assigned To column in the exported excel file .Then save the file to local drivers .
Send an email using Outlook with the excel file .
If you want to do these actions automatically when items are added to SharePoint lists ,you need to created itemadded event handler or custom workflow to achieve this .
For more information about event handler and custom workflow ,you can refer to these sites: