Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Order of fields in the mailmerge recipient list in Word 2003
I am using an Access 2003 query as the data source of a Word 2003 merge
document. How can I re-arrange the the fields in the recipient list into a sensible order? And then keep them in that order? Changing the order of fields in the query seems to have a random effect or none at all on the field order of the recipient list. Any ideas? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Order of fields in the mailmerge recipient list in Word 2003
You can temporarily resequence the columns in the Mailmerge recipients
dialog box by dragging and dropping the column headers, but I know of no way to make those changes stick. Broadly speaking, Word tries to recognise field names commonly used in name and address lists (in English, anyway - I have no idea what it does in other language versions) and imposes its preferred sequence. If you use field names that it does not recognise, Word seems to use the sequence used in the the query. So one thing you can do is a. put the fields you want in the sequence you want in the query b. use an alias name for each field. A simple way that leaves the names readable but does not appear to interfere with anything else is to prefix every name by an underscore ("_"), e.g. use _firstname, _lastname etc. (For example in the SQL you might have SELECT firstname as _firstname, lastname as _lastname FROM mytable ) b. prefix every field name by a number (say) so that Word will not recognise it Peter Jamieson "Dan Newcombe" Dan wrote in message ... I am using an Access 2003 query as the data source of a Word 2003 merge document. How can I re-arrange the the fields in the recipient list into a sensible order? And then keep them in that order? Changing the order of fields in the query seems to have a random effect or none at all on the field order of the recipient list. Any ideas? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Order of fields in the mailmerge recipient list in Word 2003
That works, thanks very much.
One thing to note is that to see the desired effect of any changes made to the source query the data connection needs to be re-established. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Order of fields in the mailmerge recipient list in Word 2003
I used to go through that loop, but then I discovered that clicking the
Refresh button in the Mail Merge Recipients dialog box seems to re-issue the query and get the new column names. It may not not always work, though... Peter Jamieson "Dan Newcombe" wrote in message ... That works, thanks very much. One thing to note is that to see the desired effect of any changes made to the source query the data connection needs to be re-established. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word should catalog misspelled words to study. | Microsoft Word Help | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
Word & WordPerfect | Microsoft Word Help | |||
Problems migrating Word 97 mailmerge document to Word 2003 | Mailmerge |