• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How can I include a cell reference in a webpage hyperlink?

danefw

New Member
I am trying to help my mom by making a hyperlink in her excel contact list which will automatically open her Yahoo Mail in a Compose message and populate the email addresses from the sheet.
I have used =TEXTJOIN to link all of the addresses with a semicolon between. This will allow her to add and delete emails up to 400 rows (more than enough).
I have found this hyperlink "https://compose.mail.yahoo.com/?to=your@email.com" which links directly to the Yahoo Mail Compose screen and places "your@email.com" in the TO: field.
I have successfully inserted this into the Excel sheet with =HYPERLINK("https://compose.mail.yahoo.com/?to=your@email.com","Email All") and it works.
I want to replace the "your@email.com" with the cell reference to the =TEXTJOIN result, but it is not recognizing the result and only opens a blank email.

She is very limited in her computer knowledge and has been struggling even with Copy/Paste, so I want to make this as simple as possible. Any help is VERY much appreciated
 
You didn't say exactly, but I think you're saying you try to put a cell reference into the To: box of the new email. Wouldn't you have to put the string that is in that cell?

If you don't understand what I mean (I don't think I said it very clearly) or if it doesn't work, I suppose we need to get into code details.
 
Back
Top