Merging multiple records into one document
I am not very profficient with code so may need some help to get this working.
I am working on a Mac using Office 2008. If this won't work on a Mac, I can beg one of my kids for short term use on one of their school laptops which I think have the latest version on Office. 2011?
We have an excel database of students that have joined a youth group in our church. Annual fees are charged per child.
What I would like to do is create a merged letter to send home to each family, listing the child and dollar amount due and if possible, number of participants and total due.
The database has a row for each child and is set up as follows:
Name, Last | Name, First | Address | Parent Names | Parent Email | Grade | Dues.
The word document looks similar to this:
Due for the 2014-15 enrollment
For your child(ren):
______________________________
______________________________
______________________________
______________________________ X $_______________per child = $__________
(number of participants) (total)
I've tried reading the document shared by Paul Edstein but I am completely lost.
Thanks for any help you can give me
Lani
|