Microsoft Office Forums Finalized mail merge, and every 4th row of data is missing

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-17-2019, 11:44 AM
lzbreath lzbreath is offline Finalized mail merge, and every 4th row of data is missing Windows 10 Finalized mail merge, and every 4th row of data is missing Office 2010
Novice
Finalized mail merge, and every 4th row of data is missing
 
Join Date: Oct 2019
Posts: 2
lzbreath is on a distinguished road
Talking Finalized mail merge, and every 4th row of data is missing

I'm merging from excel into a table in word 2010. Table has two columns of data coming from excel.



I've put the "nextrecord" at the end of each cell in the table (except the last), and at the beginning of each cell (except the first). No matter which way I try, the first 3 or 4 cells are accurate, then it skips to every 4th row from the excel data.

Also, I've ensured there are no extra spaces or redundant rules in the word table.


Thanks,
/e
Reply With Quote
  #2  
Old 10-18-2019, 04:16 AM
gmayor's Avatar
gmayor gmayor is offline Finalized mail merge, and every 4th row of data is missing Windows 10 Finalized mail merge, and every 4th row of data is missing Office 2016
Expert
 
Join Date: Aug 2014
Posts: 3,007
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

Next Record jumps to the next record. If you have it twice in a cell it will skip records.

This sounds like a Many to One merge - see Merge Many To One
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 10-18-2019, 06:23 AM
lzbreath lzbreath is offline Finalized mail merge, and every 4th row of data is missing Windows 10 Finalized mail merge, and every 4th row of data is missing Office 2010
Novice
Finalized mail merge, and every 4th row of data is missing
 
Join Date: Oct 2019
Posts: 2
lzbreath is on a distinguished road
Default

Thanks so much for your input.

I'm basically moving content from several columns in a single excel file, to cells in a table in the word file.

For instance:
column G of the excel will be placed cell by cell into column 2 of the table
column J of the excel will be placed cell by cell into column 3 of the table
...and so on

I've checked that "nextrecord" is never repeated in a cell in the word file.
Attached Images
File Type: png merge image.PNG (12.5 KB, 5 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge - data sources Sarki76 Mail Merge 2 09-02-2019 01:28 AM
Finalized mail merge, and every 4th row of data is missing Use a the data from a mail merge field pttsv Mail Merge 4 12-19-2017 02:40 PM
Finalized mail merge, and every 4th row of data is missing Updating mail merge data jaydee456 Mail Merge 3 12-23-2016 08:01 PM
Is data merge and mail merge the same thing? ikearns Mail Merge 1 09-12-2014 03:53 AM
Finalized mail merge, and every 4th row of data is missing Collation of mail merge data Nibbles Excel 2 04-16-2013 07:59 AM


All times are GMT -7. The time now is 01:06 PM.


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