Using Mail Merge to create summary report in ONE document

[ChandaS]

Good Afternoon.... My question has probably been answered in other threads, but I cannot find a scenario that matches my needs close enough to assimilate the code to make this work.

I have created a database with responses to a questionnaire. 24 agencies have responded to 21 questions. My Excel set up is such that agency name and 21 questions are the field names (column headers) and their corresponding agency names and responses make up the records (rows).

I need to provide a summary report (in one document) where each question is listed and the responses from each agency is listed beneath each question (preferably as a bullet list). See example:



1. Do you have backpack campsites within your park?
* Yes, we have 5 backpack campsites. -- NC State parks
* No, we do not have any backpack campsites. -- TN State parks

2. Are your campsites accessible by a vehicle?
* No, all sites must be accessed via trail. -- NC State parks


And so on.... By the end of the document, all 21 questions will be listed with each agency's response listed beneath. (Note that not all questions were answered and so would have empty fields.)

Using traditional mail merge methods, this isn't working. I looked at several examples of code that could be used, but honestly, I haven't worked in code enough to translate it to what I need to do.

Can anyone provide direction? Would this be more suitable set up in Access?

Many thanks! Chanda

[macropod]

A mailmerge requires each record (in the case each question) to be on a separate row, with each field (in this case the responses & agency names) in a separate column. Your description suggests the data need to be transposed to get that structure.