Hello
I want to include hyperlink in a cell to send mail. In the subject of the email, the product version should be picked form a cell I2 on the sheet.
I tried by using following formula in cell A4 of attached file.
=HYPERLINK("mailto:[email protected]?subject=Product Feedback " &I2,"For queries, feedback or suggestions, please write to [email protected]." & CHAR(10) & "Pl. mention your contact details with feedback.")
In this option, the entire cell gets the same format.
But, I would like only the email address to be seen as hyperlink and the second line to be in smaller font. (as seen in cell A9 of same sheet).
How can I change the above formula to make the look and feel of cell A4 similar to A9?
(I am also open to use a macro for this.)
Pl. hover over both the cells to loook at the subject of email generated in each case. I can embed version no. in first case (cell A4) , but don't know how to do it in second case (cell A9).
So, any of following will work for me:-
a) change the above formula to make the look and feel of cell A4 similar to A9?
b) embed version no. from cell I2 in cell A9
Can someone suggest a solution?
Thanks
Ajay
Bookmarks