Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 05-09-2017, 10:19 AM
BADeb BADeb is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: May 2017
Posts: 3
BADeb is on a distinguished road
Default Merging in Word across not down

I have a document I want to merge my names into, but I need them to go down and not across. I have a list of names for each crew, see example.

A crew D crew B crew C crew
Lastname, First Lastname, First Lastname, First Lastname, First



I have my query in order by Crew, then last name. I need it to fill in each starting with the A crew, then the D crew, B crew, C crew. It is filling with A, D, B, C. So the rest of my A crew people are coming up in different crew lists in my word document.

How can I make it fill down, then the next column in my document?

Thank you.
Attached Images
File Type: png Word Merge doc.PNG (21.8 KB, 8 views)

Last edited by BADeb; 05-09-2017 at 12:51 PM. Reason: Adding file
Reply With Quote
  #2  
Old 05-09-2017, 05:59 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,468
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Word Label merges output the records using an across-then-down arrangement. If you need a down-then-across arrangement:
1. In the Labels dialog, click New Document to create a new document based on the label definition you have chosen.
2. Display table gridlines (Table Tools | Layout | Table | View Gridlines) and nonprinting characters (Ctrl+* or Home | Paragraph | Show/Hide ) so you can see what you're doing.
3. Delete all cells except the first. If there is a spacer column, note its width beforehand.
4. On the Page Layout tab, in the Page Setup group, click Columns and choose More Columns...
5. In the Columns dialog, select however many labels across your label stationery had
6. In the Spacing box, set the width to the original spacer column width or, if it had none, 0
7. If necessary, set the column width to your label width.
8. Change the mailmerge type to 'Directory'.
9. Run the mailmerge.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging Word with Excel sing'n Mail Merge 3 04-10-2017 03:43 PM
Merging two tables in WORD with VBA ffinley Word VBA 3 03-14-2017 07:43 PM
Word - Merging from Access kevinegg45 Mail Merge 2 10-30-2012 09:10 AM
Merging Multiple Word files into One Stattovic Word 0 01-06-2010 07:19 AM
HELP! Merging Excel to Word peevenjo Mail Merge 0 07-06-2007 03:24 PM


All times are GMT -7. The time now is 01:42 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft