Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-18-2017, 11:13 AM
ARS ARS is offline Mail Merge records out of order Windows 7 32bit Mail Merge records out of order Office 2007
Novice
Mail Merge records out of order
 
Join Date: Oct 2017
Posts: 3
ARS is on a distinguished road
Default Mail Merge records out of order

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.
Reply With Quote
  #2  
Old 10-18-2017, 01:16 PM
macropod's Avatar
macropod macropod is offline Mail Merge records out of order Windows 7 64bit Mail Merge records out of order 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

This really isn't a mailmerge issue; it's an issue with your database design. Database questions should be posted in an appropriate database forum, for example http://www.accessforums.net/ for Access related discussions.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-18-2017, 02:10 PM
ARS ARS is offline Mail Merge records out of order Windows 7 32bit Mail Merge records out of order Office 2007
Novice
Mail Merge records out of order
 
Join Date: Oct 2017
Posts: 3
ARS is on a distinguished road
Default

Thank you for your response. I followed the link you posted but could not find anything related to my question. I guess I'm confused how it could be a design flaw. I've used this function for over a decade with no problems.
Do you know the answer to my question and how to fix it?
Thanks.
Reply With Quote
  #4  
Old 10-18-2017, 02:13 PM
macropod's Avatar
macropod macropod is offline Mail Merge records out of order Windows 7 64bit Mail Merge records out of order 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

No, I don't know the answer - I'm not a database expert. You should ask questions of this kind in a database forum.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge records out of order Many records to One Mail Merge Document CONFUSEDOPSMANAGER Mail Merge 1 05-08-2017 02:56 PM
Mail Merge records out of order How do I mail merge records into table columns with more than one merge field? tech123 Mail Merge 1 04-26-2017 07:13 PM
Mail merge--skipping records 623bookends Mail Merge 2 01-12-2014 06:02 AM
Mail Merge records out of order Multiple mail merge records on the same page allenglishboy Mail Merge 3 07-18-2012 06:22 AM
Mail Merge records out of order Mail Merge - Many Records for Each Addressee awalker1970 Mail Merge 1 12-31-2010 11:52 AM

Other Forums: Access Forums

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