Email Macro: File Name Is Subject

Hi all,

I'm using the below macro to send spreadsheets and it works all fine and dandy:

ActiveWorkbook.SendMail Recipients:="[email protected]", Subject:="CGGI Report (Bristol)_061110", ReturnReceipt:=False

I'm wondering, however, if there's a means of getting the VBA to use the file name as the subject header in the e-mail. In the above example the (Bristol) part continually changes as the reports come from over 200 locations in the UK.

Any ideas much apppreciated,

TIA,

SamuelT

Nice site - bookmarked! Unfortunately, it doesn't solve my issue. But thanks, I'm sure to be using that resource at some point!