Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 10-19-2017, 06:17 AM
ARS ARS is offline Random placement of merged records Windows 7 32bit Random placement of merged records Office 2007
Novice
Random placement of merged records
 
Join Date: Oct 2017
Posts: 3
ARS is on a distinguished road
Default Random placement of merged records

I am using office 2007. When I enter a new record to merge into a letter it goes in random order in the data base. Its supped to be in the last place in the data base. This is important because I use the number as part of the account number to retrieve the record later. It just started doing this shortly after I hit record 1000.



For example: The first record entered into a blank data base would automatically be numbered 1. The second would be number 2 and so on. I am currently at number 1029 and when I enter a new record it could go to position 875 and each record beyond 875 advances one position, so what was 902 is now 903. The new entry should automatically be number 1030 but the data base randomly assigns the position.

Has anyone experience this and/or know how to fix it?
Thanks.
  #2  
Old 10-19-2017, 06:47 AM
Charles Kenyon Charles Kenyon is offline Random placement of merged records Windows 10 Random placement of merged records Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,082
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Sorry, I've always used Excel for my records and added a row at the end.
  #3  
Old 10-19-2017, 02:03 PM
macropod's Avatar
macropod macropod is offline Random placement of merged records Windows 7 64bit Random placement of merged records 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

ARS: You have already asked this question once and been told what you should do: https://www.msofficeforums.com/mail-...out-order.html

Kindly don't post duplicate questions. Thread closed.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Closed Thread

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Random placement of merged records Significant Blank Space At Top Of Page When Records Merged 1 Per Page JennEx Mail Merge 18 05-05-2017 05:33 AM
Random placement of merged records When using a 'Master' template, if number of records change, subsequent records will not be read MailMergeConfused Mail Merge 5 07-28-2016 05:07 PM
some records disappear after emailing mail merged file Dr Ennui Mail Merge 1 06-10-2015 04:17 PM
Random placement of merged records Mail merge placeholder placement in document Old Dude Mail Merge 3 12-11-2014 07:30 PM
reliable graphics placement eNGiNe Word 4 02-03-2012 01:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:24 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