#1
|
|||
|
|||
Using Mail Merge to create summary report in ONE document
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 |
#2
|
||||
|
||||
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.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
mail merge, merge in one document |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge to create specific number of table rows | flackend | Mail Merge | 4 | 12-01-2023 02:49 PM |
How to use mail merge to create a list sorted by category in Word | elisa2013 | Mail Merge | 5 | 03-14-2014 02:35 AM |
Urgent Supprt Need to Create Mail Merge letter | risnasmhd | Mail Merge | 1 | 09-29-2013 08:11 PM |
Creating Report based on 'Task Summary' and 'Sub Tasks' | alijahed | Project | 1 | 02-01-2013 04:20 AM |
Summary Report for Individual Task | tmanzan | Project | 7 | 01-15-2013 12:45 PM |