macro to send email
 

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

macro to send email
 

Not sure without seeing the code but you will probably need
"Sick Leave: " & worksheets("sheetname").cells(1,4)
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"scheduler" wrote:

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

macro to send email
 

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.
--
scheduler


"John Bundy" wrote:

Not sure without seeing the code but you will probably need
"Sick Leave: " & worksheets("sheetname").cells(1,4)
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"scheduler" wrote:

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