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.
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?
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.
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.
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?
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.
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.