Mail Merge Recipient Problems Bec 5/10/2007 4:30:01 AM Currently using Word 2002 I created my mail merge and data source. For some reason it keeps moving my current recipients that I have finished entering to the beginning of the recipient list. My recipient was up to 4000 so I created a new one it was working fine then started to do this. I have sorted the records so the appear how and where I want. But as soon as I go out of the file and then back in again it's all jumbled. Please HELP!!!

Re: Mail Merge Recipient Problems "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 5/10/2007 7:25:52 AM One thing that you could do is use the data source with a Directory type mailmerge main document in which you set up the merge fields in the cells of a one row table. When you execute that merge to a new document, that document will contain a row of data for each record in the data source. You can then insert a row at the top of that table into which you insert the names of the merge fields and then use the Table>Sort facility in Word to get it into the order that you want. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Bec" <Bec[ at ]discussions.microsoft.com> wrote in message news:3CAE72A0-33BB-4321-B995-16FF8A85E9D6[ at ]microsoft.com... [Quoted Text] > Currently using Word 2002 I created my mail merge and data source. For > some > reason it keeps moving my current recipients that I have finished entering > to > the beginning of the recipient list. My recipient was up to 4000 so I > created > a new one it was working fine then started to do this. I have sorted the > records so the appear how and where I want. But as soon as I go out of the > file and then back in again it's all jumbled. Please HELP!!!

Re: Mail Merge Recipient Problems Bec 5/10/2007 10:21:02 PM Thanks Doug, Whilst this may solve the problem in the short term it won't help me in the long term. I use mail merge everyday and it's part of my normal duties so will be a pain to have to do this everytime I use it. I have opened the data source in Access and sorted it the way it needs to be but when I save it and then go back to word to open the data source it's not the saved file. Is there anyway for this to work and how? "Doug Robbins - Word MVP" wrote: [Quoted Text] > One thing that you could do is use the data source with a Directory type > mailmerge main document in which you set up the merge fields in the cells of > a one row table. When you execute that merge to a new document, that > document will contain a row of data for each record in the data source. You > can then insert a row at the top of that table into which you insert the > names of the merge fields and then use the Table>Sort facility in Word to > get it into the order that you want. > > -- > Hope this helps. > > Please reply to the newsgroup unless you wish to avail yourself of my > services on a paid consulting basis. > > Doug Robbins - Word MVP > > "Bec" <Bec[ at ]discussions.microsoft.com> wrote in message > news:3CAE72A0-33BB-4321-B995-16FF8A85E9D6[ at ]microsoft.com... > > Currently using Word 2002 I created my mail merge and data source. For > > some > > reason it keeps moving my current recipients that I have finished entering > > to > > the beginning of the recipient list. My recipient was up to 4000 so I > > created > > a new one it was working fine then started to do this. I have sorted the > > records so the appear how and where I want. But as soon as I go out of the > > file and then back in again it's all jumbled. Please HELP!!! > > >

Re: Mail Merge Recipient Problems "Peter Jamieson" <pjj[ at ]KillmapSpjjnet.demon.co.uk> 5/10/2007 10:40:32 PM Sorting your data source in Access probably isn't going to be enough, because Access tables have no "natural" sequence. What is more likely to work is... 1. to create an Access query that a. selects all the records from the table you want to use b. specifies the sort sequence you want and 2. to use that query as your data source. If that doesn't work, sorry... Peter Jamieson "Bec" <Bec[ at ]discussions.microsoft.com> wrote in message news:A78D498F-6566-474D-A112-98E46C1F9DF1[ at ]microsoft.com... [Quoted Text] > Thanks Doug, > > Whilst this may solve the problem in the short term it won't help me in > the > long term. I use mail merge everyday and it's part of my normal duties so > will be a pain to have to do this everytime I use it. I have opened the > data > source in Access and sorted it the way it needs to be but when I save it > and > then go back to word to open the data source it's not the saved file. Is > there anyway for this to work and how? > > "Doug Robbins - Word MVP" wrote: > >> One thing that you could do is use the data source with a Directory type >> mailmerge main document in which you set up the merge fields in the cells >> of >> a one row table. When you execute that merge to a new document, that >> document will contain a row of data for each record in the data source. >> You >> can then insert a row at the top of that table into which you insert the >> names of the merge fields and then use the Table>Sort facility in Word to >> get it into the order that you want. >> >> -- >> Hope this helps. >> >> Please reply to the newsgroup unless you wish to avail yourself of my >> services on a paid consulting basis. >> >> Doug Robbins - Word MVP >> >> "Bec" <Bec[ at ]discussions.microsoft.com> wrote in message >> news:3CAE72A0-33BB-4321-B995-16FF8A85E9D6[ at ]microsoft.com... >> > Currently using Word 2002 I created my mail merge and data source. For >> > some >> > reason it keeps moving my current recipients that I have finished >> > entering >> > to >> > the beginning of the recipient list. My recipient was up to 4000 so I >> > created >> > a new one it was working fine then started to do this. I have sorted >> > the >> > records so the appear how and where I want. But as soon as I go out of >> > the >> > file and then back in again it's all jumbled. Please HELP!!! >> >> >>