Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
reference cell
Hi
I want to send an email from a cell in excell2003 I can insert a link and set the email address from the dia box What I also want to do is to pick up from another cell the email address for "cc", the subject, and a very short message(body) For example: The email link in cell A1 is subject=A2;&cc=A3&body=A4. When the email editor starts the the email address in the TO (A1) field shows up correct, but the cc field, the subject field, and the body field contains "A2", "A3", "A4" respectively. I need them the show the actual text (including the email address) in those cells |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
reference cell
Ben,
I have provided an example @ http://www.HelpExcel.com/examples The name of the spreadsheet is sendMail.xls -- http://HelpExcel.com "Ben" wrote: Hi I want to send an email from a cell in excell2003 I can insert a link and set the email address from the dia box What I also want to do is to pick up from another cell the email address for "cc", the subject, and a very short message(body) For example: The email link in cell A1 is subject=A2;&cc=A3&body=A4. When the email editor starts the the email address in the TO (A1) field shows up correct, but the cc field, the subject field, and the body field contains "A2", "A3", "A4" respectively. I need them the show the actual text (including the email address) in those cells |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
How do I anchor a cell reference? | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Cell Reference Math | Excel Worksheet Functions |