+ Reply to Thread
Results 1 to 6 of 6

link data from an excel file to word

  1. #1
    Registered User
    Join Date
    06-07-2017
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    3

    link data from an excel file to word

    I'm looking to link data from an excel file to word. I can already do this with blocks of data but the formatting isn't 'fluid' with the word doc.

    I want to look as if it was a custom document.

    Example in Word:

    Thank you for attending my event regarding (Insert From Excel) on (Insert date from excel). As discussed at the event we strive to meet the needs of (named organization from exce) and will do everything in our power to do so.



    This is a simplified version of a multi-page document I'm trying to create.

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: link data from an excel file to word

    Do you want copy format of text from Excel?

    You can format linked text in Word (mailmerge)

  3. #3
    Registered User
    Join Date
    06-07-2017
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    3

    Re: link data from an excel file to word

    I do want to format of the text, but I want to insert it specific cells into word. So if A1 has the name "Josh" I want that to be placed in a specific spot in Word, possibly mid sentence.

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: link data from an excel file to word

    it's possible with mailmerge (Tab Mailing)
    see attachments
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-07-2017
    Location
    Los Angeles
    MS-Off Ver
    2016
    Posts
    3

    Re: link data from an excel file to word

    awesome. Thank you!

  6. #6
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: link data from an excel file to word

    You are welcome

    If that takes care of your original question, please click Add Reputation (bottom left corner) select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. link data in word to excel
    By juergen(barcelona) in forum Excel General
    Replies: 2
    Last Post: 02-22-2017, 05:18 AM
  2. Replies: 9
    Last Post: 06-29-2015, 01:40 PM
  3. Replies: 0
    Last Post: 10-20-2014, 07:25 AM
  4. How to link Excel file with Word File
    By pareshvm in forum Excel General
    Replies: 4
    Last Post: 05-18-2012, 04:07 AM
  5. link a WORD file into an Excel sheet
    By carsto in forum Excel General
    Replies: 12
    Last Post: 12-20-2006, 11:39 PM
  6. Excel file link with word file
    By kilianli in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-10-2006, 04:20 AM
  7. Replies: 0
    Last Post: 11-03-2005, 08:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1