Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Importing data into a template

Options
  • 06-12-2011 6:18pm
    #1
    signup070
    Users Awaiting Email Confirmation Posts: 90 ✭✭


    Hi

    I hope this is in the correct forum.

    Sorry if my question is a bit vague.

    I want to print certificates for a students’ doing a course.
    As there will be many certificates (hundreds) to print I’m looking to set up an efficient way of doing it.

    I am looking for advice on possible solutions.

    One way I was half thinking about was:

    Of setting up a template of some sort.
    Maybe a MS word document and have section where the individual data (names, scores.. etc) can be imported from another file such as a spreadsheet.

    Suggestions on how I might get started on this or other different possible methods greatly appreciated.

    Thank you.


Comments

  • Options
    #2
    carveone
    Registered Users Posts: 1,216 ✭✭✭carveone


    I believe what you are referring to is a mail merge. As in:

    Dear <field1>,

    you have received the grade <field2> in subject <field3>.

    etc..

    That kind of thing????

    Yes - database and spreadsheet data merges are par for the course...


  • Options
    #3
    signup070
    Users Awaiting Email Confirmation Posts: 90 ✭✭signup070


    I didn't realise there was a built in function called mail merge.
    Thanks for your reply.


  • Options
    #4
    carveone
    Registered Users Posts: 1,216 ✭✭✭carveone


    signup070 wrote: »
    I didn't realise there was a built in function called mail merge.
    Thanks for your reply.

    No problem. It's one of those annoying features that is only evident after you know what it is called. If you don't know the magic name you're pretty much hosed :p

    Mail merge was originally used to create mass mailing form letters which is why it has that name. But now it allows you to create large numbers of documents from any template and a data source.

    I've seen people in large companies do mail merge manually, which is pretty distressing!


  • Options
    #5
    signup070
    Users Awaiting Email Confirmation Posts: 90 ✭✭signup070


    Just in case anyone else needs to do a similar task with mail merge
    Here is a very simple clear video that explains how it is done:

    https://www.youtube.com/watch?v=Ty5XlSrHGXQ


Advertisement