If its a single event, I would select the range, copy it to a new workbook
and then send the new workbook as an attachment.

Regards
Kev Nurse