Linking Excel Cell to Shared Contacts

Status
Not open for further replies.
Outlook version
Outlook 2016 64 bit
Email Account
Office 365 Exchange
Hello All,

I'm new here, but have read through many articles on the site for various issues. I apologize if this has been covered somewhere in the forums that I've been unable to locate....

I work for a property management company. I have a spreadsheet that is designed to track every property we manage, and on that spreadsheet I have columns that list the appropriate property manager for each property.
upload_2016-9-6_16-16-12.png


Above is an example. Our company uses Office 365, and we have a company shared contact list. I would like to create a hyperlink between "Jane Doe" and "John Doe" and their respective vCards in Outlook. So when I click on their name in the Excel spreadsheet, it opens their contact info in Outlook. I know this is possible if the vCards are stored on our local file server, but is there a way to do this if they're stored on our - I guess it would be sharepoint?

Thank you!
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
You can try the method here - Using Outlook Links - which uses <Outlook:Contacts/~Name> format, including the brackets. You'll need to enabled outlook:// as a protocol for it to work - i haven't tested it in 2016 to see if it is still supported.

Shortcuts and the Missing Outlook:// Protocol - make sure you use the correct path to your outlook.
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
LOl. if i could read my own site - it looks like it does work for 2016 (as it works for 2013). I'll add a registry key for 2016 32-bit in a few minutes.
 
Outlook version
Outlook 2016 64 bit
Email Account
Office 365 Exchange
Hey Diane,

Thank you for your help with this. I've made some progress towards accomplishing this, but have run into an issue. I am able to successfully link to folders within my Outlook, but am still having trouble linking to the shared contacts folder I created on our Sharepoint. I followed the method here to create it: Create a company Shared Contacts folder in Office 365 | Cogmotive Reports Blog

Here is a screenshot of the public folders/contact list in my Outlook.
upload_2016-10-18_13-52-18.png


Here are the variations of the link I've tried to use to link to Outlook from the excel document:

<Outlook://Public Folders/All Public Folders/DPMG Public Folders/DPMG Shared Contacts/~(Contact name)

<Outlook://Public Folders/
I did this one just to see if it would open the Outlook folder. It wouldn't.

I am the owner of these folders, and the admin to our organization, so I don't think my user is being restricted in any way. Does Microsoft have some kind of restriction that prevents Excel from accessing files on Outlook that are stored in Sharepoint or something like that? Or am I just missing something simple?

Thanks Again,
Zach
 

Attachments

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
i don't think there is any reason why they shouldn't work - do you get any errors?
 
Outlook version
Outlook 2016 64 bit
Email Account
Office 365 Exchange
Here is the error that I receive. It seems to think that the formatting of the link is incorrect, but I've tried entering it the way they suggest with %20 for spaces as well. I'm stumped! It has something to do with the public folders, because I am successfully linking to any other folders.

upload_2016-10-19_10-26-6.png
 
Outlook version
Outlook 2016 64 bit
Email Account
Office 365 Exchange
Alright... The address was incorrect to access these folders:
upload_2016-10-21_13-41-18.png


It had to be written like this:
outlook://Public%20Folders%20-%20User@domain/All%20Public%20Folders/DPMG%20Public%20Folders/DPMG%20Shared%20Contacts/

This works fine to access the DPMG Shared Contacts... However, when trying to pull up an individual item in the contact list, it receives the following error.
upload_2016-10-21_13-40-42.png


Here is an example of the hyperlink I'm using: outlook://Public%20Folders%20-%20User@domain.com/All%20Public%20Folders/DPMG%20Public%20Folders/DPMG%20Shared%20Contacts/~Test

Any ideas?

Thanks!
 
Outlook version
Outlook 2016 64 bit
Email Account
Office 365 Exchange
Alright... The address was incorrect to access these folders:
View attachment 1810

It had to be written like this:
outlook://Public%20Folders%20-%20User@domain/All%20Public%20Folders/DPMG%20Public%20Folders/DPMG%20Shared%20Contacts/

This works fine to access the DPMG Shared Contacts... However, when trying to pull up an individual item in the contact list, it receives the following error.View attachment 1809

Here is an example of the hyperlink I'm using: outlook://Public%20Folders%20-%20User@domain.com/All%20Public%20Folders/DPMG%20Public%20Folders/DPMG%20Shared%20Contacts/~Test

Any ideas?

Thanks!
Edit: Upon Googling the error, I found that this error occurs when Google Apps conflicts with something in Outlook. I do have a Gmail account tied to this profile on my computer. To nullify that, I went to our backup computer, created a new Outlook profile and tried following the link. I receive the same error.
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
B Linking from Excel to public outlook 2010 calendar. Using Outlook 0
M linking projects and tasks data to access or excel BCM (Business Contact Manager) 1
P Run Time Error 91 when linking contact to task in VBA Outlook VBA and Custom Forms 1
Travis Lloyd Linking Outlook 2016 Desktop To POP3 Acc't On Android Phone Using Outlook.com accounts in Outlook 2
B Can't expose sender email address when linking outlook to access Using Outlook 3
Andrew Hawkins Linking tasks Using Outlook 1
N linking an already sent/rec'd email to contact record like it did in 2000 Using Outlook 0
C Linking e-mails BCM (Business Contact Manager) 1
K Need help concerning emails linking to BCM. BCM (Business Contact Manager) 0
P Linking email responses to initial email sent Using Outlook 5
J Linking Contacts to a Message Where the Contact isn't an Addressee Using Outlook 1
J Custom Contacts: Linking button to website Using Outlook 4
M Custom Contact form queries (date control & contact/calender linking) Using Outlook 1
R Can't use "manage linking and tracking" BCM (Business Contact Manager) 10
M Outlook 2010 - linking appointments to contact activities Outlook Wishlist 9
K add an email to a business contact without linking/tracking sender BCM (Business Contact Manager) 0
K add an email to an account without linking and tracking the email address BCM (Business Contact Manager) 0
C BCM2010, address book &amp; email linking Using Outlook 1
B linking outlook to hotmail Using Outlook 1
M Problem Linking Outlook 2010 to Access 2010 Using Outlook 2
C Linking e-mail messages to Business Contact Manager records does not save the attachments in the ema Using Outlook 1
P Linking outlook items to the contact screen Using Outlook 1
K Linking/sharing calendar in Sharepoint Workspace 2010 with calendar in Outlook 2010 Using Outlook 1
L BCM 2010 Linking A Business Contact to Multiple Accounts or Projects Using Outlook 1
L Issue with hyper-linking to url adddress in email Using Outlook 1
S Linking Microsoft Outlook to AOL email Using Outlook 1
D Linking Emails BCM 2007 Using Outlook 1
S Directly embedding video in an e-mail (not linking to one) Using Outlook 1
J Linking One Note to other task folders in outlook other than "tasks" Using Outlook 4
L Linking from email to websites Using Outlook 1
M Linking Contacts to appointments or meetings when there is no email address (in Office 2010 Professional Plus Using Outlook 1
T mobileme or itunes linking problem Using Outlook 1
D Linking my outlook phone Using Outlook 1
K Importing data into BCM User Defined Fields (check box and drop down list varieties) &amp; linking Business Contacts to Accounts Using Outlook 2
W Linking dropdown values Outlook VBA and Custom Forms 1
H Not all Email folders appearing in Manage E-mail Auto-linking BCM (Business Contact Manager) 1
G Linking Outlook to Access for Contacts in Access Outlook VBA and Custom Forms 3
S Sharing BCM contacts and linking items to records BCM (Business Contact Manager) 1
K Linking Information from Accounts to Business Contacts Manager BCM (Business Contact Manager) 1
L Linking a Business Contact to multiple Accounts? BCM (Business Contact Manager) 2
K Auto-linking emails by default shared DB BCM 2007 on SQL 2008 BCM (Business Contact Manager) 4
L Out of memory errors and Auto-linking hangs BCM (Business Contact Manager) 2
N Extract Outlook emails to excel Outlook VBA and Custom Forms 2
M Extract all links from Outlook email, send to Excel Using Outlook 2
O Email not leaving Outbox when using Excel VBA to sync Outlook account Outlook VBA and Custom Forms 4
C Pull Outlook shared calendars items from Excel Outlook VBA and Custom Forms 4
S How to export urls from email to excel and check the status of the url ? New Slipstick.com Articles 6
S save email from excel Outlook VBA and Custom Forms 1
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
C Trying to populate an appointment ComboBox from Excel Outlook VBA and Custom Forms 2
Similar threads


















































Top