Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I'm trying to find a way to link to an e-mail from my Google Spreadsheet. We use our spreadsheet as a way to track bugs, issues, to-dos, and milestone timelines (we've tried other apps, this works best). It would be great if we could reference/link to an e-mail so that we can provide additional information. Otherwise, I'm assuming converting the e-mail to a Doc and then linking, is that possible?

Thanks in advance!

Update: I would like to attach the body of the e-mail or at least link to it. For instance, say I got an email from Bob regarding the status of 'Feature A', I would like to link to that e-mail. I was thinking of converting relevant e-mails to documents and then putting it in the right folder, but I want to link to it, rather than say "Look at Document - Bob Email Re: Feature A".

share|improve this question
    
You have to be a little bit more detailed.. If I understand you correctly you have a list of members that have emails and some additional data like title, role etc and you want to display this info when you just writing their emails? –  Lipis Jul 21 '10 at 17:54
    
Please make it clear if you want include an e-mail address, attach an e-mail as a file, or link to an email in, say, gmail. –  Ben Gartner Jul 21 '10 at 19:07
add comment

4 Answers 4

There is Google Labs feature in Gmail to convert email conversation to Google Docs; then you can copy the URL of the Docs that you just created and insert it as a link from another Docs.

share|improve this answer
add comment

Assuming you want the email there for more information, and you want others to be able to access this email, it might be best to import the email into Evernote or another note-taking application that you use and then give it a share url from there.

share|improve this answer
add comment

My interpretation is that you want to add a link to your spreadsheet that leads to a Google Mail message?

Open the email message in Google Mail. The URL in the address bar is the link you want to use. I do this all the time with my own personal task tracking.

However, if multiple people are using your spreadsheet system and they all have their own non-shared accounts, I'm not so sure how useful that link to an email message will be. I believe only the person who's mailbox contains the message will be able to use the link.

share|improve this answer
add comment

You could use the VLOOKUP function.

Example on how to use it:

Let's say you have table with your members like this:

    |          A          |      B      |      C      |
--------------------------------------------------------
 1  |       E-mail        |    Name     |   Company   |
--------------------------------------------------------
 2  | bill@microsoft.com  | Bill Gates  |  Microsoft  | 
 3  | sergey@google.com   | Sergey Brin |  Google     | 
 4  | steve@apple.com     | Steve Jobs  |  Apple      | 
  1. Select the table
  2. Right click on it and Define named range...
  3. Give it a name: data
  4. Go to cell A20 and write there steve@apple.com
  5. Go to cell B20 and write =VLOOKUP(A20, data, 2, FALSE)
  6. Check what happened :)
share|improve this answer
    
I can give you more details if needed... :) –  Lipis Jul 21 '10 at 19:57
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.