Quote:
Originally Posted by Guessed
You might need to post a sample Excel file that shows your data structure so we can suggest a way to produce a report like this.
I suspect that this is not something that is suited to a Mail Merge report in Word. It does however look like something you could do in Excel with a Pivot Table or possibly in Microsoft Access with a SQL query and report based on that query. It will be important to see how your data is tabulated to work out a method of producing this report.
|
I have added an attachment of the excel export from our application software. I got the idea to do it via mail merge after creating a label mail merge and thought I might be able to do multiple records on a single page instead of records on multiple labels.
I thought the directory mail merge was the answer because I could put names under the headings like address lines, and just skip the names I didn't want. I just couldn't get them to skip correctly.
BTW, your profile picture is one of my favorite Gary Larson Far Side cartoons!