Import data from excel

Discussion in 'Word' started by Adrian007, Sep 12, 2016.

  1. Adrian007


    Sep 12, 2016
    Likes Received:
    Hello office community and thank you for letting me in.Without further introduction,here's my problem. A small recruitment company (5 ladies) has asked me for help in automatising their workflow, which currently is a slow and painful process.Basically what they have now is an excel "database" which contains personal data for the people that are to be employed.For these people,due to the beureucracy there is a tremendous amount of paperwork to be done before being actually employed (they have to have numerous documents completed by the company,documents which have to be stamped/authorised by both the Romanian and German authorities (the firm looks for people for agriculture work in Germany,recruiting them from romania). What I want to to, is to turn those documents into templates with fillable forms and make word populate them ,for example populate the name field with data from the name column in excel, the marital status field from the marital status column and so on. The question is ,is this possible? If so,how? Before commenting, I looked for solutions myself, and I found mail merge to be something, from your experience,is this the way to go or should I use another solution?Thank you.
    Adrian007, Sep 12, 2016
    1. Advertisements

  2. Adrian007

    macropod Microsoft MVP

    Mar 2, 2012
    Likes Received:
    Your problem outline suggests mailmerge would probably be the most appropriate tool to use. A mailmerge can be used to process a single record, or thousands of records. A macro-driven mailmerge can even save the output as a separate file for each record. For the mailmerge basics, see:
    Once you've created the mailmerge main document, it's a simple matter to save it so it's available for generating subsequent letters.
    See also:
    That page has many useful mailmerge tips on how to format the mergefield outputs, plus macros for generating individual output files and/or splitting a single output file.
    macropod, Sep 13, 2016
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.