Generating Word Report from a Checklist

  • Thread starter Thread starter yingying001
  • Start date Start date
Y

yingying001

I need to generate a report in word based on a checklist. The checklist
will have a list of questions, and checklist users will answer
"yes" or "no" to each question. In the report, I will need all
the questions have "yes" answers go to one paragraph, and all the
"no" goes to another paragraph. I don't know how to accomplish
this task.

I used mail merge before, and it is only limited to how to merge name &
address to create label.
 
I need to generate a report in word based on a checklist. The checklist
will have a list of questions, and checklist users will answer
"yes" or "no" to each question. In the report, I will need all
the questions have "yes" answers go to one paragraph, and all the
"no" goes to another paragraph. I don't know how to accomplish
this task.

I used mail merge before, and it is only limited to how to merge name &
address to create label.
Click to expand...

You could try using a protected form. Once the user fills out the form
with there yes or no, you should be able to take the bookmarks from the
form and places them whereever you want. It will take some Marco
writing with VBA but it can be done.

~Amanda~
 
Back
Top