View Single Post
 
Old 10-28-2014, 01:41 PM
LaniKaye LaniKaye is offline Mac OS X Office 2008 for Mac
Novice
 
Join Date: Oct 2014
Posts: 2
LaniKaye is on a distinguished road
Default 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
Reply With Quote