Mail Merge Multiple Rows format issue
I am new to this forum and have used a previous post (luisaranda/macropod) for coding for my specific need which tracks family member volunteers who work various swim meet positions for various points which I aggregate.
The code I "borrowed" used a numeric system, which I do not require, which indents the printout results which created a further few issues that I can not solve
Here is a snippet from the mail merge results which shows my problem
- the second family member points are not being captured (John Jones Timekeeper points) and if the second family member works multiple swim meets (Peter Smith) , the indentation is incorrect and is missing the points.
- I saw somewhere that the mail merge can aggregate totals which I would like to display at the "Family" level
-and I want to eventually e mail each family their summaries
I have attached my sample files since I have run out of room to show the mail merge coding
Any help will be appreciated
1. Jones FAMILY Total Points
1.1. Betty Clinic Strokes Clinic 20 Points
1.2. John Meet - Provincial Timekeeper
2. Smith FAMILY Total Points
2.1. Marg Meet - Time Trial Starter 40 Points
2.2. Peter Clinic Strokes Clinic
2.2.1. Meet - Division 1 Timekeeper
2.2.2. Meet - Division 2 Timekeeper
2.2.3. Meet - Division 3 Timekeeper
2.2.4. Meet - Time Trial Timekeeper
|