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