 |
 | 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 / July 2006Mail Merge Sort not working
I have a client using a mail merge macro I wrote. One option is to use the reciepant sort of the data source. The sort works fine if the user chooses simple fileds like Last_Name or District_Name. But the user wants these sorted by parcel numbers. These are actual property parcel numbers from a Tax Claim Bureau so that they are formatted in strange ways, like: 01,002.-098L.-000 01,002.-098M.-000 02,002.-095B.-000 03,003.-077..-001 01,003.-051..-002 When I try the sort, it comes out in a strange order. At first it almost looks like descending, even though I have ascending choosen, but after about three records it starts going all over the place. I've taken this data file in Excel and Access and both sort these numbers correctly. Only Word seems to have the problem. Does any have any suggestions? Put the data into Access and use a query in Access to sort it the way you want it and as the datasource for the mailmerge.  SignatureHope 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 >I have a client using a mail merge macro I wrote. One option is to use the > reciepant sort of the data source. The sort works fine if the user [quoted text clipped - 16 lines] > seems > to have the problem. Does any have any suggestions? Actually, that is an option I can not use. I can't be sure if the user has Access or knows how to use it. This mail merge is part of a macro set that is used first to FTP the data file from UNIX to Windows then used in the form files. I have a form containing buttons, one of which brings up the MailMerge Query Option diaolog box where the user should be able to sort the data how he wants. The users are all over my State and sometimes want to print these documents in different orders. Is there something different in the way that Word is sorting the special characters, periods and commas, then in either Excell or Access? > Put the data into Access and use a query in Access to sort it the way you > want it and as the datasource for the mailmerge. [quoted text clipped - 19 lines] > > seems > > to have the problem. Does any have any suggestions? With the small sample of data that you included in your post, I cannot replicate the problem. Send me a file with data that exhibits the problem and I will take a look at it. SignatureHope 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 > Actually, that is an option I can not use. I can't be sure if the user > has [quoted text clipped - 39 lines] >> > seems >> > to have the problem. Does any have any suggestions? Sure. Where do I send the file to. > With the small sample of data that you included in your post, I cannot > replicate the problem. Send me a file with data that exhibits the problem [quoted text clipped - 43 lines] > >> > seems > >> > to have the problem. Does any have any suggestions? What you need to remove from my email address should be obvious. SignatureHope 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 > Sure. Where do I send the file to. > [quoted text clipped - 56 lines] >> >> > seems >> >> > to have the problem. Does any have any suggestions?
|
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.