| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use excel to send email without macro | Excel Discussion (Misc queries) | |||
| Macro to send email to multiple addresses | Excel Worksheet Functions | |||
| Can I send a doc to group of email addresses via a macro button? | Excel Discussion (Misc queries) | |||
| ***** PLEASE HELP **** Send an email from Excel to outlook with an automatic macro | Excel Discussion (Misc queries) | |||
| Can you send a Macro to someone else by email? | Excel Discussion (Misc queries) | |||
Linear Mode
