VBA to create an email with file path

[matratus34]

Hi all,
I've got a macro that saves my report to a certain drive with a name based on some variables.

Is it easy to input some VBA to create an email with the just the file path and send to joebloggs@123.com?

This is the code at the end of my macro that saves the file to the location that I want in my email - thisYear & thisWeek are both variables that create the file name.


sPath = "\\mydrive.uk\common\FINANCE\02_Sales\Weekly"
sFileName = "W" & thisYear & "_" & thisWeek
ActiveWorkbook.SaveAs (sPath & sFileName)



Thanks in advance

 

[Stiuart_W]

Yes that should be pretty easy

Check out Ron de bruin's site for some examples https://www.rondebruin.nl/win/section1.htm