Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email Range of Cell Content to create subject and body from link
I have a list of email address in one worksheet named Email.
From my primary worksheet called ActivityLog I have a list created from the Email sheet so that the email address are already available via drop down menu. The ?Subject=Problem Resolution is already in the drop down. I have to double click after adding the email address to the primary sheet before it will reconize the link! How to get it to reconize that it is a link automatically. Next question: I want to use contents of cells to create email message. I want to use cells within the same row as the email address to use contents of cell to create body of message. Is this possible??? Keep in mind that each row is a different problem and could be direct to one of several email address. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email Range of Cell Content to create subject and body from link
"Hahndo" wrote: I have a list of email address in one worksheet named Email. From my primary worksheet called ActivityLog I have a list created from the Email sheet so that the email address are already available via drop down menu. The ?Subject=Problem Resolution is already in the drop down. I have to double click after adding the email address to the primary sheet before it will reconize the link! How to get it to reconize that it is a link automatically. Next question: I want to use contents of cells to create email message. I want to use cells within the same row as the email address to use contents of cell to create body of message. Is this possible??? Keep in mind that each row is a different problem and could be direct to one of several email address. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email Range of Cell Content to create subject and body from link
"Hahndo" wrote: I have a list of email address in one worksheet named Email. From my primary worksheet called ActivityLog I have a list created from the Email sheet so that the email address are already available via drop down menu. The ?Subject=Problem Resolution is already in the drop down. I have to double click after adding the email address to the primary sheet before it will reconize the link! How to get it to reconize that it is a link automatically. Next question: I want to use contents of cells to create email message. I want to use cells within the same row as the email address to use contents of cell to create body of message. Is this possible??? Keep in mind that each row is a different problem and could be direct to one of several email address. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I create a link for both content and format of the cell? | Excel Worksheet Functions | |||
Range of Cells to create body of email | Excel Worksheet Functions | |||
Defining the subject of an Email by value in range | Excel Programming | |||
How to send filtered range in email body? | Excel Programming | |||
Copy and Paste a Worksheet Range to Email Body | Excel Programming |