1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Creating an email link in Excel

Discussion in 'Business Applications' started by GreggR, Aug 16, 2007.

Thread Status:
Not open for further replies.
Advertisement
  1. GreggR

    GreggR Thread Starter

    Joined:
    Aug 16, 2007
    Messages:
    4
    This seems like it should be simple, but I don't have an answer. I want to create a link in an Excel spreadsheet that will go to and open a specific Outlook email message. I'm trying to track emails that have scanned documents attached and i want to be able to open them from the spreadsheet. How do I create that link in Excel? Thanks!
     
  2. GreggR

    GreggR Thread Starter

    Joined:
    Aug 16, 2007
    Messages:
    4
    Test! Junior member???? Humph!
     
  3. Zaurus

    Zaurus

    Joined:
    Aug 1, 2007
    Messages:
    25
    Not really sure what you mean! Excel can't directly go into Outlook and open an email. You need to open the email and save it to another folder first. You can then hyperlink from Excel to where you saved the file. To do that, Right click on the Excel cell you want to contain the hyperlink, choose Hyperlink from the drop down menu and use the "Look in" box to navigate to the folder you saved it in, click on the document you want, then click "Ok". The text in the Excel cell will now be underlined and clicking on it will open the file. This may not be what you're trying to achieve, but from what you posted it's difficult to know. Are you simply trying to list emails that have scanned documents attached and using Excel to keep an index of them for easy navigation back to them?
     
  4. GreggR

    GreggR Thread Starter

    Joined:
    Aug 16, 2007
    Messages:
    4
    Still working out some bugs in my system for doing that, but your response was a lot of help.

    (y)
     
  5. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    18,834
    GreggR, you can use Excel VBA to manipulate Outlook, you should therefore (theoretically) be able to open an email.
    You can certainly send one using VBA.
     
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/610918