Announcement

Collapse
No announcement yet.

how can i insert data form excel to word

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    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.
    Boo!

    Comment


    • #3
      Re: how can i insert data form excel to word

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

      Comment

      Working...
      X