 |
 | 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 / September 2005How do I make mail merge sort data source entries automatically?
Earlier versions of word would automatically sort entries to my data source as I input them but since I have gotten office pro 2003 it doesn't do it anymore. Now everytime I add an entry I have to view the source and sort it manually. Is there a setting that I can change that will make Word do this for me? What application holds your data? Excel? Access? Something else? Which version of Word did you use before moving to 2003? -- Cindy > Earlier versions of word would automatically sort entries to my data source > as I input them but since I have gotten office pro 2003 it doesn't do it > anymore. Now everytime I add an entry I have to view the source and sort it > manually. Is there a setting that I can change that will make Word do this > for me? The data is stored in a word table that mail merge created. I used office 2000 before. Thanks for your help!! La Vonna > What application holds your data? Excel? Access? Something else? > [quoted text clipped - 7 lines] > > manually. Is there a setting that I can change that will make Word do this > > for me? OK, now I can visualize what you mean :-) You can still work with the previous interface to enter and manage your Word table data. In the 2002/2003 section of my website's mail merge FAQ you'll find instructions on how to access the older interfaces. http://homepage/swissonline.ch/cindymeister -- Cindy > The data is stored in a word table that mail merge created. > [quoted text clipped - 14 lines] > > > manually. Is there a setting that I can change that will make Word do this > > > for me? Okay, I am sorry but I still can't find what I am looking for or maybe I am just not knowledgable enough to know that the answer is right in front of me. Let me explain. I have a list of addresses, that I am always updating, from which I print envelopes. In the 2000 mail merge, when I opened the data form and added a new entry and hit close, mail merge would automatically resort the table to make it conform to the sort order that I previously saved. Now every time I add a new entry I have to click on the view source button that opens the table and resort it manually. Is there any way to make mail merge do that by itself again? > OK, now I can visualize what you mean :-) > [quoted text clipped - 23 lines] > > > > manually. Is there a setting that I can change that will make Word do this > > > > for me? No, there isn't. -- Cindy > Okay, I am sorry but I still can't find what I am looking for or maybe I am > just not knowledgable enough to know that the answer is right in front of me. [quoted text clipped - 35 lines] > > > > > manually. Is there a setting that I can change that will make Word do this > > > > > for me? Okay, thank for all of your help though. I really appreciate it. > No, there isn't. > [quoted text clipped - 39 lines] > > > > > > manually. Is there a setting that I can change that will make Word do this > > > > > > for me? I actually found the answer to this thanks to your help!. I opened the Mail Merge Helper and clicked on the query options button. Then I entered the sort order that I wanted and it worked!! Hopefully this will help someone else in the future. Thanks again!!! > Okay, thank for all of your help though. I really appreciate it. > [quoted text clipped - 41 lines] > > > > > > > manually. Is there a setting that I can change that will make Word do this > > > > > > > for me? Could you please explain to me where I can fin the Mail Merge Helper? Is it the same as the Mail Merge Wizard? I can not find any query options button in the Mail Merge Wizard. > I actually found the answer to this thanks to your help!. I opened the Mail > Merge Helper and clicked on the query options button. Then I entered the [quoted text clipped - 48 lines] > > > > > > > > manually. Is there a setting that I can change that will make Word do this > > > > > > > > for me? See http://www.gmayor.com/mail_merge_labels_with_word_xp.htm  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Could you please explain to me where I can fin the Mail Merge Helper? > Is it the same as the Mail Merge Wizard? I can not find any query [quoted text clipped - 56 lines] >>>>>>>>> there a setting that I can change that will make Word do this >>>>>>>>> for me? JCO In Wood 2003, right click on any toolbar click on Customize go to the Commands tab, scroll down the list of Categories highlight All Commands scroll down to MailMergeHelper drag it up onto the Mail Merge Toolbar press okay. When you click on the Mail Merge Helper button that you just added to the toolbar a new window will open with three sections in it. Section 3 will allow you to choose sort and query options for your data source. Hope that this is helpful. > Could you please explain to me where I can fin the Mail Merge Helper? Is it > the same as the Mail Merge Wizard? I can not find any query options button in [quoted text clipped - 52 lines] > > > > > > > > > manually. Is there a setting that I can change that will make Word do this > > > > > > > > > for me?
|
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.