Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-19-2014, 01:41 PM
ChandaS ChandaS is offline Using Mail Merge to create summary report in ONE document Windows 7 64bit Using Mail Merge to create summary report in ONE document Office 2010 64bit
Novice
Using Mail Merge to create summary report in ONE document
 
Join Date: Dec 2014
Posts: 1
ChandaS is on a distinguished road
Question 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
Reply With Quote
  #2  
Old 12-19-2014, 10:16 PM
macropod's Avatar
macropod macropod is offline Using Mail Merge to create summary report in ONE document Windows 7 64bit Using Mail Merge to create summary report in ONE document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Tags
mail merge, merge in one document

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Mail Merge to create summary report in ONE document Mail Merge to create specific number of table rows flackend Mail Merge 4 12-01-2023 02:49 PM
Using Mail Merge to create summary report in ONE document How to use mail merge to create a list sorted by category in Word elisa2013 Mail Merge 5 03-14-2014 02:35 AM
Using Mail Merge to create summary report in ONE document Urgent Supprt Need to Create Mail Merge letter risnasmhd Mail Merge 1 09-29-2013 08:11 PM
Using Mail Merge to create summary report in ONE document Creating Report based on 'Task Summary' and 'Sub Tasks' alijahed Project 1 02-01-2013 04:20 AM
Using Mail Merge to create summary report in ONE document Summary Report for Individual Task tmanzan Project 7 01-15-2013 12:45 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:43 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft