 |
 | 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 / May 2004order of datasource fields
when using word to mail merge records in an access (2003) query the field names & columnsin the recipients list are in a different order to the query eg my query's first column may be Address but the First_Name field is shown first in the recipients field. How can I determine the order of fields in the recipient list? Thanks Sean Does running a macro containing the following commands when the mailmerge main document is the active document give you the information that you need: Dim i As Long For i = 1 To ActiveDocument.MailMerge.DataSource.FieldNames.Count MsgBox "Field Number " & i & " is " & ActiveDocument.MailMerge.DataSource.FieldNames(i).Name Next i  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 > when using word to mail merge records in an access (2003) > query the field names & columnsin the recipients list are [quoted text clipped - 7 lines] > > Thanks Sean Hi Sean303, Unfortunately, this is a case where "Word knows best". You can't influence the order, it's hard-coded into Word by what the designers of Word think is a "useful priority". I hate it; most everyone I know hates it. But we can't change it, unfortunately. > when using word to mail merge records in an access (2003) > query the field names & columnsin the recipients list are [quoted text clipped - 5 lines] > How can I determine the order of fields in the recipient > list? 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.