B
BCassedy
I'm working on finalizing a trouble ticket reporting system. With the help
of several individuals, I've just about got it taken care of. The final
piece is to have the user click on a hyperlink which will open Outlook with
the intended recipient listed.
What I would like it to also do is to copy and paste the contents of a cell
(G1) into the subject line field.
(G1 is a culmination of several cells data being put together to form a
trouble ticket number).
- if, by some fluke, it would be possible to add text to the
beginning of the subject line such as "Alert - New trouble ticket, number"
and then add the ticket number from cell G1, that would just be gravy.
I've looked at the properities for an email hyperlink, found that you could
add a subject line, but can not come up with the correct method of adding the
cell's contents.
of several individuals, I've just about got it taken care of. The final
piece is to have the user click on a hyperlink which will open Outlook with
the intended recipient listed.
What I would like it to also do is to copy and paste the contents of a cell
(G1) into the subject line field.
(G1 is a culmination of several cells data being put together to form a
trouble ticket number).
- if, by some fluke, it would be possible to add text to the
beginning of the subject line such as "Alert - New trouble ticket, number"
and then add the ticket number from cell G1, that would just be gravy.
I've looked at the properities for an email hyperlink, found that you could
add a subject line, but can not come up with the correct method of adding the
cell's contents.