order of datasource fields

[Sean303]

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

 

[Doug Robbins - Word MVP]

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


--
Please 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

 

[Cindy M -WordMVP-]

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
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?

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