Hello all,

I am in charge of sending out progress reports for individuals on our team. What I am looking to do is listed below:

1. Filter spreadsheet to show information for Kevin (I have it in Power View, but could move it to a regular tab)
2. Print that information to pdf
3. Upload that pdf to a SharePoint
4. Send a unique email to Kevin containing a link to his pdf (mail merge?)
5. Next week, when uploading the pdf to SharePoint, I would like it to overwrite the past week's pdf.

I am looking to automate this to the fullest extent. What parts are possible to automate, and any suggestions on where to begin?