Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-11-2020, 04:02 PM
Polo Polo is offline Skipping record, every 4. Mac OS X Skipping record, every 4. Office 2016
Novice
Skipping record, every 4.
 
Join Date: Mar 2020
Location: Austin, TX
Posts: 1
Polo is on a distinguished road
Default Skipping record, every 4.

I am trying to create postcards. The source is from an Excel sheet, that I saved as a .csv file. I've divided a landscape letter-size into 4 areas. I've hard typed return address, and inserted fields with

<Name> <MI> <Last> <Suffix>
<Number> <Street>
<City>, <ST> <Zip>
It fills top to bottom, left to right.




1 3
2 4


It was repeating the first record on all 4, so I added <Next Record> after addresses 1,2,and 3.


When it goes to the next page, it starts with record #6, skipping #5. It does it consistently every page, skipping #9, 14, 19, 24, 29, etc.


Help?
Reply With Quote
  #2  
Old 03-11-2020, 08:25 PM
macropod's Avatar
macropod macropod is online now Skipping record, every 4. Windows 7 64bit Skipping record, every 4. Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,340
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

You should add the «Next Record» field at the start of records 2, 3, & 4. If you use a label merge and format the first label exactly as you want it to appear, then click on 'Update labels' Word will update the rest as they should be. That said, an across-then down output is what one would ordinarily expect from a label merge.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Skipping an Index entry philippe.delobbe Mail Merge 0 04-30-2015 05:49 AM
Skipping USA as a country identifier Delta223 Mail Merge 1 04-03-2015 02:27 AM
Skipping row in mail merge table. Mulith Mail Merge 6 10-30-2014 04:32 AM
avoid duplicete record and merge the record with the existed record hemant.behere Excel 0 01-10-2012 02:53 AM
Skipping record, every 4. Skipping pages in a mail merge NewGirl Mail Merge 6 12-16-2011 07:16 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 10:43 PM.


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