i have already used ron debruin's site to set up a code to send a worksheet
via email as part of the text body which works really well (check out his
site) - thanks a heap ron!!!

what i now need to do is, in the subject line have the following text and
cell value:

Sick Leave: (D10)

where D10 is a cell containing a name (which changes) so when emailed the
subject line reads:

Sick Leave: Bob Smith

Does anyone know how to write this piece of code without upsetting the rest?


--
scheduler