macro to send email

[scheduler]

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?

 

[John Bundy]

Not sure without seeing the code but you will probably need
"Sick Leave: " & worksheets("sheetname").cells(1,4)

 

[scheduler]

not quite happening but i appreciate the help. I get the Sick Leave part but
the additional name does not appear. I tried a few variations but to no
avail.