 |
 | 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 / June 2004Sorting mail merged records alphabetically
Creating Form letters with a merge from Access database. The records merge by date entered into Access. How can I resort to merge letters alphabetically by Field Name ie: Last Name. I have tried sorting the table to be merged alphabetically but the merge still occurs in the order entered in the data base Use a query in Access to sort the records and as the data source for the mailmerge.  SignaturePlease 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 > Creating Form letters with a merge from Access database. The records merge > by date entered into Access. How can I resort to merge letters > alphabetically by Field Name ie: Last Name. I have tried sorting the table > to be merged alphabetically but the merge still occurs in the order > entered in the data base Does this count for an Excel worksheet too In other words; does the sort records function from the MailMerge Query options doesn't work with any other data source than Word data sources ----- Doug Robbins - Word MVP wrote: ---- Use a query in Access to sort the records and as the data source for the mailmerge -- 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 "Danny" <anonymous@discussions.microsoft.com> wrote in message news:23EEA4D5-1C4A-4E37-8F7B-D43033E261C5@microsoft.com.. > Creating Form letters with a merge from Access database. The records merge > by date entered into Access. How can I resort to merge letters > alphabetically by Field Name ie: Last Name. I have tried sorting the table > to be merged alphabetically but the merge still occurs in the order > entered in the data base I don't know what version of Word you are using, but in Word 2003/XP, you can sort any data source via the Mailmerge Recipients dialog by clicking on the column heading. SignaturePlease 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 > Does this count for an Excel worksheet too? > In other words; does the sort records function from the MailMerge Query options doesn't work with any other data source than Word data sources? [quoted text clipped - 18 lines] > > to be merged alphabetically but the merge still occurs in the order > > entered in the data base Thank you for your kind reaction; I'm using Office 2000; and I think I've found the answer I can sort the Excel data when I have chosen to open my Data source by the Method of using a conversionprogramm. Works fine; but my Excel data then is converted to a Word table and I must not save the changes on closing this document So it is indeed best to sort in advance in Excel, of afterwards in the Word document with the merged data Thanks again Maike Ween ----- Doug Robbins - Word MVP wrote: ---- I don't know what version of Word you are using, but in Word 2003/XP, yo can sort any data source via the Mailmerge Recipients dialog by clicking o the column heading -- 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 "Maikie" <anonymous@discussions.microsoft.com> wrote in messag news:2B25776A-1581-4300-AF93-8E6070CAB756@microsoft.com.. > Does this count for an Excel worksheet too > In other words; does the sort records function from the MailMerge Quer options doesn't work with any other data source than Word data sources >>> ----- Doug Robbins - Word MVP wrote: ---- >> Use a query in Access to sort the records and as the data source fo th > mailmerge >> -- > Please post any further questions or followup to the newsgroups fo th > benefit of others who may be interested. Unsolicited question forwarde > directly to me will only be answered on a paid consulting basis >> Hope this help > Doug Robbins - Word MV > "Danny" <anonymous@discussions.microsoft.com> wrote in messag > news:23EEA4D5-1C4A-4E37-8F7B-D43033E261C5@microsoft.com.. >> Creating Form letters with a merge from Access database. Th records merg >> by date entered into Access. How can I resort to merge letter >> alphabetically by Field Name ie: Last Name. I have tried sortin the tabl >> to be merged alphabetically but the merge still occurs in the orde >> entered in the data bas Databases (and I guess you could call Excel a database, though I would not) are much better at data manipulation than Word Processors. SignaturePlease 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 > Thank you for your kind reaction; I'm using Office 2000; and I think I've found the answer. > I can sort the Excel data when I have chosen to open my Data source by the Method of using a conversionprogramm. Works fine; but my Excel data then is converted to a Word table and I must not save the changes on closing this document. > So it is indeed best to sort in advance in Excel, of afterwards in the Word document with the merged data. > [quoted text clipped - 40 lines] > >> to be merged alphabetically but the merge still occurs in the order > >> entered in the data base Hi =?Utf-8?B?TWFpa2ll?=, > Thank you for your kind reaction; I'm using Office 2000; and I think I've found the answer. > I can sort the Excel data when I have chosen to open my Data source by the Method of using a conversionprogramm. Works fine; but my Excel data then is converted to a Word table and I must not save the changes on closing this document. > So it is indeed best to sort in advance in Excel, of afterwards in the Word document with the merged data. Where you can sort depends, with Access and Excel, how you connect to the data, as you've discovered. When you use a DDE connection (the default in Word 2000 for Excel and Access), the sorting in Excel or Access takes precedence over anything you set in Word. If you use ODBC, or the spreadsheet converter, then the sorting you set in Word will take effect. If you don't like using the converter for Excel, try ODBC :-) 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.