#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
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. |
#4
|
||||
|
||||
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] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Many records to One Mail Merge Document | CONFUSEDOPSMANAGER | Mail Merge | 1 | 05-08-2017 02:56 PM |
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 |
Multiple mail merge records on the same page | allenglishboy | Mail Merge | 3 | 07-18-2012 06:22 AM |
Mail Merge - Many Records for Each Addressee | awalker1970 | Mail Merge | 1 | 12-31-2010 11:52 AM |