Very Complicated Mail Merge

[IceMan1981]

Hello,

I am trying to create a merge template of my faculty "database" (not a true database, but a massive spreadsheet that acts as a reporitory of info). The issue I am running into is a faculty member will have several activities listed, but I only want 1 document generated with all of the historic activities.

For example: I want to take a table similar to the one below and use it to populate a summary sheet that brings all of the unique activities of each faculty member into one document as such:

Faculty Name: [Name]
Status: [Status]
List of Activities: [Act. 1] [Date]
[Act. 2] [Date]
[Act. 3] [Date] etc.

I can do basic mail merges, but the part I am running into is creating 1 single document that keeps ALL activities together since they are unique activities to the faculty member. A typical merge will will create a single document for each activity rather than collect all activities on one document. I used to use a Google Apps Script called formMule that use to do something similar to it, but Apps Scripts are written in Java Script. I imagine I will need a VBA for this, but I am not familiar enough to create it on my own. I can modify a script to make it work, but not create it. Any help you can give is appreciated.


[TABLE="class: grid, width: 500"]
<TBODY>[TR]
[TD]Fac. ID
[/TD]
[TD]Name
[/TD]
[TD]Status
[/TD]
[TD]Activity
[/TD]
[TD]Date
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]John
[/TD]
[TD]Full Time
[/TD]
[TD]Act. 1
[/TD]
[TD]1-1-11
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]John
[/TD]
[TD]Full Time
[/TD]
[TD]Act. 2
[/TD]
[TD]2-2-11
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Jane
[/TD]
[TD]Part Time
[/TD]
[TD]Act. 1
[/TD]
[TD]3-3-11
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]John
[/TD]
[TD]Full Time
[/TD]
[TD]Act. 3
[/TD]
[TD]4-4-11
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Jane
[/TD]
[TD]Part Time
[/TD]
[TD]Act. 2
[/TD]
[TD]5-5-11
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Bill
[/TD]
[TD]Part Time
[/TD]
[TD]Act. 1
[/TD]
[TD]6-6-11
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Bill
[/TD]
[TD]Part Time
[/TD]
[TD]Act. 2
[/TD]
[TD]7-7-11
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]John
[/TD]
[TD]Full Time
[/TD]
[TD]Act. 4
[/TD]
[TD]8-8-11
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Bill
[/TD]
[TD]Part Time
[/TD]
[TD]Act. 3
[/TD]
[TD]9-9-11
[/TD]
[/TR]
</TBODY>[/TABLE]