How to display text in a cell with a mailto concatenated hyperlink?

**JRR007** · 10-22-2012, 10:42 AM

I have a spreadsheet where I click the name of a company and up pops a pre filled out email with adressee, subject and body. However, I have two issues: (1) I need the cell to display the "company name" rather than the below formula & (2) The concatenated value in the cell I am referencing is a date, in date form. When my email pops up the date appears as a 5 digit number, such as 41195. What is the proper formula to correct these two issues?

Thanks, in advance!

=HYPERLINK(CONCATENATE("mailto:First.Last@Company.com&subject="&B2,"&body=Hello... ",O18))

**JRR007** · 10-22-2012, 10:56 AM

I have figured out my first question. But I still need to know how to make the cell show text rather than the formula. This is what I used for the date formatting: ... "&body=Hello "&TEXT(O18,"mm/dd") ))

**JRR007** · 10-22-2012, 11:18 AM

How would you insert multiple lines of: "&body=Hello "&TEXT(O18,"mm/dd") )) I have tried to continue on and get an error. I would like to make it say for example (see my desired output): 1st trim: "&TEXT(O18,"mm/dd") %0A%0A 2nd trim: "&TEXT(O19,"mm/dd") %0A%0A thrid trim: "&TEXT(O20,"mm/dd") %0A%0A Thank you,

How to display text in a cell with a mailto concatenated hyperlink?

LinkBack

Thread Tools

Rate This Thread

Display

How to display text in a cell with a mailto concatenated hyperlink?

Re: How to display text in a cell with a mailto concatenated hyperlink?

Re: How to display text in a cell with a mailto concatenated hyperlink?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions