1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

question about data from excel to work

Discussion in 'Microsoft Office' started by Pooja Kamdar, Feb 15, 2010.

  1. Pooja Kamdar

    Pooja Kamdar Flightless Bird

    I am trying to take input from an excel sheet and mailmerge it to
    word....the thing is I want to make it so from here on out ..if I change
    something in the excel sheet it automatically updates on word as
    well..if not a mail merger what can I use ?




    --
    Pooja Kamdar
     
  2. macropod

    macropod Flightless Bird

    Hi Pooja Kamdar,

    You can link the Word document to the Excel workbook, so that any changes in the Excel workbook will be reflected in the Word
    document. To do this:
    1. copy the source range in the Excel workbook
    2. in the Word document, use Edit|Paste Special > Paste Link and choose the paste format you want to use.
    In Word, you have the option to set a 'update automatic links at open' setting, which will ensure the Word document always opens
    with the latest updates to the Excel workbook.

    --
    Cheers
    macropod
    [Microsoft MVP - Word]


    "Pooja Kamdar" <Pooja.Kamdar.5bf7a16@officefrustration.com> wrote in message news:pooja.Kamdar.5bf7a16@officefrustration.com...
    >
    > I am trying to take input from an excel sheet and mailmerge it to
    > word....the thing is I want to make it so from here on out ..if I change
    > something in the excel sheet it automatically updates on word as
    > well..if not a mail merger what can I use ?
    >
    >
    >
    >
    > --
    > Pooja Kamdar
     

Share This Page