2 Easy Methods to Link the Names in Excel to Corresponding Outlook Contacts

Many users ask for methods to link the names in an Excel worksheet to the relevant Outlook contacts. Now, in this article, we will introduce 2 such ways.

For instance, you have a list of names in an Excel file. Now, you want to link them to the associated contacts in your Outlook. To be specific, you wish that as long as you click on the links, its corresponding Outlook contacts will display. Now, in the followings, we will teach 2 approaches to realize it with ease.

Method 1: Link to Exported vCard Files

  1. First off, open the specific Excel file. As shown in the following figure, I’ll link the first name “Aaron” to the Outlook contact “Aaron” as an instance.Open Excel File
  2. Then, launch Outlook and locate the specific contact.Select an Outlook Contact
  3. Next, go to “File” > “Save As”.
  4. In the popup “Save As” dialog box, navigate to the specific local folder to save the exported contact and ensure “vCard Files” in the “Save as type” and lastly click “Save”.Save Contact as vCard File
  5. After that, return to the Excel file.
  6. Subsequently, select the cells you want to add the link to the Outlook contact.
  7. Next, press “Ctrl + K” button.
  8. In the “Insert Hyperlink” dialog box, browse to the folder where you save the vCard file, pitch on the specific vCard file, modify the text to display and click “OK”, like the screenshot below.Insert Hyperlink to vCard File
  9. After that, you’ll see that there is a link in the selected cell.Click Link in Cell
  10. When you click it, a message will show up, in which select “OK”.Confirm Open vCard File
  11. At once, the corresponding Outlook contact will open, like the image below.Opened vCard File in Outlook

If you have multiple names in Excel thus want to batch save multiple contacts as vCard files, please refer to “2 Methods to Batch Export Multiple Outlook Contacts as vCard Files“.

Method 2: Link to Contacts through MS OneNote

  1. In the first place, insure MS OneNote is installed on your PC.
  2. Then, in Outlook, select a certain Outlook contact.
  3. Next, click the “OneNote” button in “Actions” group on “Home” tab.OneNote Action
  4. Subsequently, MS OneNote will display with a section enabled, in which you can see the linked contact.Contact Link in OneNote
  5. Now, you need to select the “Link to Outlook Item” link and press “Ctrl + C” to copy it.Copy "Link to Outlook Item"
  6. Later, open the Excel file and locate the specific name
  7. Afterwards, paste the copied link into the right cell with source formatting.Paste OneNote Link to Cell
  8. Finally, you can click the link, which will open the associated Outlook contact at once.Open Associated Contact

Repair Your Outlook File

Similar to Excel file, Outlook data file can be damaged readily in that there are too many risks and threats nowadays. For instance, improper shutdown can result in Outlook damage directly. Hence, it is prudent to prepare a powerful and reliable PST repair tool in advance, such as DataNumen Outlook Repair. In this way, even if Outlook PST file is corrupt, you still can repair it like a cork.

Author Introduction:

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including sql repair and outlook repair software products. For more information visit www.datanumen.com