macro to send email

G

Guest

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?
 
G

Guest

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro to creat & send email 2
Send Email 1
Excel Send Lotus Notes Mails With VBA Macro Excel 0
Send Email With Cell Conent as Part of the Subject 1
email problem 2
Email 4
Code to send email to address within selection in Excel workbook 3
Macro to send email automatically. 3

Top