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}" ""}

Your INCLUDTEXT field should be something along the lines of:
{INCLUDETEXT "C:\\Users\\jjospeh\\OneDrive\\Documents\\SPOR TS - SCOPES BY DISCIPLINE.docx" ACOUSTICS}
If you open the document on OneDrive, then select the bookmarked range and paste it into the destination document using Paste Special with the 'paste link' option, the resulting LINK field will give the correct filepath.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you macropod! The "paste link" worked for me as long as I removed the INCLUDETEXT

{IF {REF ACOUSTICS} = "TRUE" "{ LINK WORD.DOCUMENT.12 "HTTPS://***" "ACOUSTICS" \A \H }" ""}

Your suggestion that references the sync'd C: drive location also worked; however, i assumed it would not work properly for other users utilizing the same document, so I opted for the above.
Thank you for the help.