Embedding Linked Documents

Written by Allen Wyatt (last updated January 3, 2023)
This tip applies to Word 2007, 2010, 2013, 2016, 2019, and Word in Microsoft 365


Jennifer has a Word document that has links to hundreds of other documents. Now she wants to replace each of those links with the actual document referenced. (In other words, she wants to embed the referenced documents.) She wonders if there is a global way to do this instead of having to do each document separately.

The solution depends on how, exactly, you have the other documents linked to your current document. If you inserted the contents of another file using the Text from File command (Insert tab | Object | Text from File) and chose to insert as a link, then the file contents are actually added through the use of the INCLUDETEXT field. As with any other field, you can unlink the field in this manner:

  1. Select the field. (Or, if you have lots of fields, press Ctrl+A to select the entire document.)
  2. Press Ctrl+Shift+F9. Word unlinks the fields, leaving the text that the fields represented.

If your documents are linked using hyperlinks, then the process is a bit more difficult. The reason is simple: a hyperlink is only a pointer to the other document, not the actual contents of that other document. This means that you need to come up with a way to open the other document, grab its contents, and stuff it into the current document in place of the hyperlink.

This type of work is perfect for a macro to do. The following example actually steps backwards through each hyperlink and inserts the files:

Sub InsertDocs()
    Dim aRange As Range
    Dim J As Long

    Set aRange = ActiveDocument.Range
    ' Go backwards because hyperlinks are deleted as processed
    For J = aRange.Hyperlinks.Count to 1 Step -1
        With aRange.Hyperlinks(J)
            ' Process only hyperlinks to documents
            If InStr(.Address, ".doc") > 0 Then
                .Range.Select
                On Error GoTo noFile
                .Follow
                On Error GoTo 0
                ActiveDocument.Range.Copy
                ActiveDocument.Close
                Selection.Paste
            End If
            GoTo nextFile
noFile:
            On Error GoTo 0
            MsgBox "Cannot open file " & .Address
nextFile:
        End With
    Next J
End Sub

Note that the macro checks the hyperlink to make sure it contains the letters ".doc". This doesn't mean that it is limited only to the old .DOC files, as the test would also match the letters ".docx" and ".docm".

Note:

If you would like to know how to use the macros described on this page (or on any other page on the WordTips sites), I've prepared a special page that includes helpful information. Click here to open that special page in a new browser tab.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (6824) applies to Microsoft Word 2007, 2010, 2013, 2016, 2019, and Word in Microsoft 365.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Changing Measurement Units

When working in Word's dialog boxes, most people understand that you should enter measurements using inches. If you don't ...

Discover More

Word Count for a Portion of a Document

Word doesn't provide a field that allows you to return a word count for a portion of your document, but you can create ...

Discover More

Finding the Nth Occurrence of a Character

The FIND and SEARCH functions are great for finding the initial occurrence of a character in a text string, but what if ...

Discover More

Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!

More WordTips (ribbon)

Pasting a Hyperlink

When you paste information into a document, you can specify that it be inserted as a hyperlink rather than as normal ...

Discover More

Replacing Plain Text with a Hyperlink

Active hyperlinks can be a desired feature in some types of documents. If you want to replace multiple instances of plain ...

Discover More

Creating Hyperlinks from E-mail Addresses

Got a document that has a whole raft of e-mail address in it? You can easily convert all of them to clickable hyperlinks ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] (all 7 characters, in the sequence shown) in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is five more than 3?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)


This Site

Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.

Videos
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.