Penny Arcade Forums› Help / Advice Forum
As was foretold, we've added advertisements to the forums! If you have questions, or if you encounter any bugs, please visit this thread: https://forums.penny-arcade.com/discussion/240191/forum-advertisement-faq-and-reports-thread/
Options

Auto Update Word File Based on Excel cells

ZonkytonkmanZonkytonkman Registered User regular
edited November 2007 in Help / Advice Forum
So I want an application form that I have to automatically fill itself out with data that I have in an excel file.

Say I input the name of a project "Proj1" in cell a1 in sheet "Project Description" in Excel.

Now I have "Application1" as a word document in a nearby folder, and several fields in that word document need to say the Project Name.

Is there someway for word to pluck that data out of that cell and display it automatically? It's the same form every time, with the same excel setup for all of the info.

Thanks guys

Zonkytonkman on

Posts

  • Options
    rannelvisrannelvis Registered User regular
    edited November 2007
    what you're looking to do is called a mail merge. the google has fine instructions on it

    rannelvis on
  • Options
    ZonkytonkmanZonkytonkman Registered User regular
    edited November 2007
    hmm. that might work. They seem to think it's only for like, letter heads and stuff though. I need to fill out big ass forms.

    Zonkytonkman on
Sign In or Register to comment.
Penny Arcade Forums› Help / Advice Forum