 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / April 2004Skipping Records
I'm having the same problem as Hile. Word mailmerge document is for a catalog and data source is an Access database query. Every third or fouth record skips. I've created the word mailmerge document several times but am getting same result. I am using Word 2000, Access 2000 and Windows XP Home. I've looked for any special characters (i.e., double quotes") and have none. I also cut and pasted the query into an excel spreadsheet and tested the merge. Same result . . . skipping records. Any advice? Do you have a <<Next Record>> field there somewhere where it is not needed? -- Please post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP > I'm having the same problem as Hile. Word mailmerge document is for a catalog and data source is an Access database query. Every third or fouth record skips. I've created the word mailmerge document several times but am getting same result. I am using Word 2000, Access 2000 and Windows XP Home. I've looked for any special characters (i.e., double quotes") and have none. I also cut and pasted the query into an excel spreadsheet and tested the merge. Same result . . . skipping records. Any advice? No, I have only one <<Next Record>> at the end of the merge field list. Doug, I've done these types of merges many times before but not with Windows XP. Thanks for any help you can give me ----- Doug Robbins - Word MVP wrote: ---- Do you have a <<Next Record>> field there somewhere where it is not needed - Please post any further questions or followup to the newsgroups for th benefit of others who may be interested. Unsolicited questions forwarde directly to me will only be answered on a paid consulting basis Hope this help Doug Robbins - Word MV "Kate" <anonymous@discussions.microsoft.com> wrote in messag news:D17F62FF-08A4-4356-A8A6-DC7F7A173A4B@microsoft.com.. > I'm having the same problem as Hile. Word mailmerge document is for catalog and data source is an Access database query. Every third or fout record skips. I've created the word mailmerge document several times but a getting same result. I am using Word 2000, Access 2000 and Windows XP Home I've looked for any special characters (i.e., double quotes") and have none I also cut and pasted the query into an excel spreadsheet and tested th merge. Same result . . . skipping records. Any advice Hi Kate, Can you provide some more information on how the mailmerge main document is laid out. What type of merge is it - Formletters, Labels, Catalog (or Directory as it is called in Word XP and later). I don't quite under stand the "one <<Next Record>> at the end of the merge field list" There is nothing about Windows XP that would cause the merge to behave differently from running it under earlier versions of Windows. -- Please post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP > No, I have only one <<Next Record>> at the end of the merge field list. Doug, I've done these types of merges many times before but not with Windows XP. Thanks for any help you can give me. > ----- Doug Robbins - Word MVP wrote: ----- > [quoted text clipped - 16 lines] > I also cut and pasted the query into an excel spreadsheet and tested the > merge. Same result . . . skipping records. Any advice? Hi =?Utf-8?B?S2F0ZQ==?=, > I have only one <<Next Record>> at the end of the merge field list. I'd say this is likely the problem. If you want ALL the records to come across in a catalog merge then you wouldn't need a "Next record" in there... (Note: I can imagine situations when this might be desired due to layout considerations, but not at the *end* of a list of merge fields) Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.