Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: how can i insert data form excel to word

  1. #1
    Join Date
    8th December 2005
    Posts
    2

    how can i insert data form excel to word

    I have a file called table.xls and table.doc in attachment. In table.xls i have a simple table with name, cogname and age, and table.doc i have somekind of report where name, cogname and age should be inserted (underlined words). The end result should be that excel inserts somehow (i guess using macro) for example name: franko, cogname: burcul and age: 22 in their places in table.doc report so i should be able to print it for each person (franko, ana and ivan, see table.xls) instead of manually inserting each name, cogname and age in their places and then printing them

    thanks allot
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    14th July 2004
    Posts
    10,539

    Re: how can i insert data form excel to word

    I just downloaded both files.

    I then went to Tools>Mail Merge... in the Word document.

    I choose Create>Form Letters... and Active Document.

    I then went to Get Data>Open Data Source... and navigated to the Excel spreadsheet.

    I was then able to insert the data from the spreadsheet using Insert Merge Field.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    8th December 2005
    Posts
    2

    Re: how can i insert data form excel to word

    thanks allot. this has helped me very much. thanks again.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Insert A Word Object In Excel, Type, Then Resize
    By mjschukas in forum EXCEL HELP
    Replies: 4
    Last Post: March 23rd, 2007, 13:11
  2. Export data into specific form areas in a Word Doc
    By duugg in forum Excel and/or Word Help
    Replies: 5
    Last Post: April 22nd, 2006, 22:59
  3. Word doc as INPUT FORM to Excel
    By WildLatin23 in forum Excel and/or Word Help
    Replies: 1
    Last Post: February 1st, 2003, 12:28

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
  •  
porno