I've got my VBA that saves the whole worksheet as a filename in a cell and date-stamp, looking for an addition to the code that will send an email too. Cell with email address is E8.
Private Sub CommandButton1_Click()
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _...