Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-28-2014, 06:01 AM
ragoo ragoo is offline trouble setting excel to import correctly into mail merge. Not using typical address fields Mac OS X trouble setting excel to import correctly into mail merge. Not using typical address fields Office for Mac 2011
Novice
trouble setting excel to import correctly into mail merge. Not using typical address fields
 
Join Date: Oct 2014
Posts: 1
ragoo is on a distinguished road
Question trouble setting excel to import correctly into mail merge. Not using typical address fields

Hello,

I am trying to figure out how to import information into a Word document using the mail merge tool. I have done this in the past successfully but for some reason it is not working.

I conducted interviews and have the respondents answers in an excel spreadsheet. Down the left column I have the questions they answered typed in. Across the top row I have the individuals name that answered the question. The corrolating cells have their answers. In the past I have been able to do this and then use the mail merge function in Word to important this information so all the recipients answers would show up under the appropriate question. For example:



Why do you think the sky is blue? (excel A2)

Not sure (excel B2)
It has white in it too (excel B3)
Because it goes on forever (excel B4)


For some reason, I cannot get it to work. The mail merge place holder only shows placeholders for across the rows and will not let me choose place holder down the column. So instead I get all the answers and not the question. And I only get one row. It is not importing all the information.

If you understand what I am asking or explaining, can you please offer suggestions?

Thank you.
Rachel
Reply With Quote
  #2  
Old 10-28-2014, 03:42 PM
macropod's Avatar
macropod macropod is offline trouble setting excel to import correctly into mail merge. Not using typical address fields Windows 7 64bit trouble setting excel to import correctly into mail merge. Not using typical address fields 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 all the data for a single record to be on the same row. Consequently, you would at least need each questions and its answers on a single row. For a multiple-question scenario, where there is a fixed number of records per interview, you could use NextRecord fields to get the additional rows.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
excel data, mail merge, place holder

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
trouble setting excel to import correctly into mail merge. Not using typical address fields Mail merge: single label set-up/template set-up/Excel import/what am I doing wrong? brunofirst Mail Merge 7 02-27-2014 02:30 PM
trouble setting excel to import correctly into mail merge. Not using typical address fields Mail Merge: cannot display the field in Excel correctly derricklo1980 Mail Merge 5 08-16-2012 07:15 PM
trouble setting excel to import correctly into mail merge. Not using typical address fields Mail Merge: cannot display the field in Excel correctly derricklo1980 Excel 1 08-16-2012 12:51 AM
Mail Merge Trouble bha19 Mail Merge 0 07-31-2011 12:30 PM
trouble setting excel to import correctly into mail merge. Not using typical address fields Date not transfering to mail merge correctly tonywatsonmail Mail Merge 1 07-01-2011 05:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:35 PM.


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