+ Reply to Thread
Results 1 to 1 of 1

Append text from a cell in email hyperlink

  1. #1
    Forum Contributor
    Join Date
    03-11-2010
    Location
    India
    MS-Off Ver
    2010
    Posts
    268

    Append text from a cell in email hyperlink

    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.
    Please Login or Register  to view this content.
    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
    Attached Files Attached Files
    Last edited by ajaykgarg; 05-28-2010 at 07:21 AM. Reason: solved

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1