Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-02-2021, 09:24 AM
TheMapper TheMapper is offline Mail Merge checkboxes Windows 10 Mail Merge checkboxes Office 2019
Novice
Mail Merge checkboxes
 
Join Date: Nov 2021
Posts: 5
TheMapper is on a distinguished road
Default Mail Merge checkboxes

I am trying to fill out a form using mail merge and I am having trouble with checkboxes.


Attached is the image from the survey that someone would take from their mobile device and press the appropriate response. The second image is what excel records as the response and the third image is my word document that I am wanting the data to check. How do I it? Any and all help will be greatly appreciated. Thank you.
Attached Images
File Type: jpg Sur123_question.JPG (19.7 KB, 6 views)
File Type: jpg ExcelData3feet.JPG (15.2 KB, 6 views)
File Type: jpg WordDoc3feet.JPG (17.9 KB, 6 views)
Reply With Quote
  #2  
Old 11-02-2021, 10:10 AM
TheMapper TheMapper is offline Mail Merge checkboxes Windows 10 Mail Merge checkboxes Office 2019
Novice
Mail Merge checkboxes
 
Join Date: Nov 2021
Posts: 5
TheMapper is on a distinguished road
Default

This is what I am putting in.
Attached Images
File Type: jpg MMinput.jpg (73.4 KB, 6 views)
Reply With Quote
  #3  
Old 11-02-2021, 10:12 AM
TheMapper TheMapper is offline Mail Merge checkboxes Windows 10 Mail Merge checkboxes Office 2019
Novice
Mail Merge checkboxes
 
Join Date: Nov 2021
Posts: 5
TheMapper is on a distinguished road
Default

When I go to preview, I am not getting anything.
Reply With Quote
  #4  
Old 11-02-2021, 10:58 AM
TheMapper TheMapper is offline Mail Merge checkboxes Windows 10 Mail Merge checkboxes Office 2019
Novice
Mail Merge checkboxes
 
Join Date: Nov 2021
Posts: 5
TheMapper is on a distinguished road
Default

I finally have it working.
Reply With Quote
  #5  
Old 11-03-2021, 12:50 PM
TheMapper TheMapper is offline Mail Merge checkboxes Windows 10 Mail Merge checkboxes Office 2019
Novice
Mail Merge checkboxes
 
Join Date: Nov 2021
Posts: 5
TheMapper is on a distinguished road
Default

I had 78 questions with 5 possible responses that was a lot of work. Is there some way to expedite this process?
Reply With Quote
  #6  
Old 11-03-2021, 03:47 PM
Guessed's Avatar
Guessed Guessed is offline Mail Merge checkboxes Windows 10 Mail Merge checkboxes Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 2,798
Guessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud ofGuessed has much to be proud of
Default

I would be looking at the source data and do the transformation there. For instance, in Excel, build the formula so there is a field there that contains the result you need so you can just drop it in directly in Word.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge checkboxes Is there a way to do a mail merge type of addition of data after a mail merge has been done? mtandino Word 4 06-01-2021 02:00 PM
Mail Merge checkboxes Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file sureshbvs Word VBA 1 03-12-2021 05:42 AM
Mail Merge checkboxes Mail Merge with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge djrexy Mail Merge 1 05-20-2020 04:04 PM
Merge documents;Formular with Checkboxes Rekun Word VBA 0 07-11-2018 11:51 AM
Mail merge how to link mail merge field value to a column heading dsummers Mail Merge 1 05-08-2014 02:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:52 PM.


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