trouble setting excel to import correctly into mail merge. Not using typical address fields

		Microsoft Office Forums > Microsoft Word > Mail Merge
trouble setting excel to import correctly into mail merge. Not using typical address fields

FAQ

Thread Tools

Display Modes

10-28-2014, 03:42 PM

macropod

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,962

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]

Tags

excel data, mail merge, place holder

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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
Mail Merge: cannot display the field in Excel correctly	derricklo1980	Mail Merge	5	08-16-2012 07:15 PM
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
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:38 AM.