View Single Post
 
Old 06-08-2020, 12:23 PM
jjoseph jjoseph is offline Windows XP Office 2016
Novice
 
Join Date: Aug 2019
Posts: 2
jjoseph is on a distinguished road
Default insert text from a bookmark in a OneDrive file

Hi,
I have a formula that inserts text from a bookmark in a separate word document. I originally set it up to read from a document on our file server and it worked great. However, now I would like to move the document with the bookmarks to OneDrive, but I am having trouble figuring out how to reference the OneDrive document in the formula. I tried just replacing the file path with the OneDrive link but it gives me a "Bookmark not defined" error. Any ideas? Thanks for your help.

Original formula: (this one works)
{IF {REF ACOUSTICS} = "TRUE" "{INCLUDETEXT "G:\\***\\SPORTS - SCOPES BY DISCIPLINE.DOCX" ACOUSTICS}" ""}

With OneDrive link: (this one does not work)
{IF {REF ACOUSTICS} = "TRUE" "{INCLUDETEXT "HTTPS://***-MY.SHAREPOINT.COM/:W:/P/***" ACOUSTICS}" ""}
Reply With Quote