Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
change order of columns in mailmerge "select recipients"
Word 2003/Access 2003 (Access 2000 database format)
I have a mailmerge linked to an Access query. It allows the user to select invitees using the "Select Recipients" utility. However, I can't seem to figure out how to make certain fields show up in the first few columns of the query records list. This makes it difficult to quickly scan and select certain recipients from the list without first shrinking the width of the columns that don't identify the recipient (i.e. name, type, event, etc.). I have tried reordering the columns in the query design view (matches SQL order), in the datasheet view. I have the query sorted on three fields (one is calculated), if that matters. None of this seems to have any bearing on the order of the fields in the "Mail Merge Recipients" window! How can I get the fields to show up in my preferred order?! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
change order of columns in mailmerge "select recipients"
Set them in that order in the Query Design in Access.
-- Hope 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 "helios" wrote in message news Word 2003/Access 2003 (Access 2000 database format) I have a mailmerge linked to an Access query. It allows the user to select invitees using the "Select Recipients" utility. However, I can't seem to figure out how to make certain fields show up in the first few columns of the query records list. This makes it difficult to quickly scan and select certain recipients from the list without first shrinking the width of the columns that don't identify the recipient (i.e. name, type, event, etc.). I have tried reordering the columns in the query design view (matches SQL order), in the datasheet view. I have the query sorted on three fields (one is calculated), if that matters. None of this seems to have any bearing on the order of the fields in the "Mail Merge Recipients" window! How can I get the fields to show up in my preferred order?! |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
change order of columns in mailmerge "select recipients"
That was my first thought, but the order almost sems arbitrary--although it
does show up in a consistent order each time. "helios" wrote: " I have tried reordering the columns in the query design view (matches SQL order), [and] in the datasheet view. ... How can I get the fields to show up in my preferred order?!" |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
change order of columns in mailmerge "select recipients"
Does this help?
The mailmerge query is based on a union query which pulls together data from seven queries. (Please--I know, but this is an inherited database and I have no time to overhaul the data management.) Is the order perhaps a prioritized conglomeration of field order in one or all of the query levels? I'll see if I can make any sense of it. "helios" wrote: Word 2003/Access 2003 (Access 2000 database format) I have a mailmerge linked to an Access query. It allows the user to select invitees using the "Select Recipients" utility. However, I can't seem to figure out how to make certain fields show up in the first few columns of the query records list. This makes it difficult to quickly scan and select certain recipients from the list without first shrinking the width of the columns that don't identify the recipient (i.e. name, type, event, etc.). I have tried reordering the columns in the query design view (matches SQL order), in the datasheet view. I have the query sorted on three fields (one is calculated), if that matters. None of this seems to have any bearing on the order of the fields in the "Mail Merge Recipients" window! How can I get the fields to show up in my preferred order?! |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
change order of columns in mailmerge "select recipients"
Try using the union query as the source for a new query in which you arrange
the fields in the required order. -- Hope 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 "helios" wrote in message ... Does this help? The mailmerge query is based on a union query which pulls together data from seven queries. (Please--I know, but this is an inherited database and I have no time to overhaul the data management.) Is the order perhaps a prioritized conglomeration of field order in one or all of the query levels? I'll see if I can make any sense of it. "helios" wrote: Word 2003/Access 2003 (Access 2000 database format) I have a mailmerge linked to an Access query. It allows the user to select invitees using the "Select Recipients" utility. However, I can't seem to figure out how to make certain fields show up in the first few columns of the query records list. This makes it difficult to quickly scan and select certain recipients from the list without first shrinking the width of the columns that don't identify the recipient (i.e. name, type, event, etc.). I have tried reordering the columns in the query design view (matches SQL order), in the datasheet view. I have the query sorted on three fields (one is calculated), if that matters. None of this seems to have any bearing on the order of the fields in the "Mail Merge Recipients" window! How can I get the fields to show up in my preferred order?! |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
change order of columns in mailmerge "select recipients"
The sequence is determined completely by Word. Word recognises certain field
names (and perhaps some variations) that are commonly used in name and address files, e.g. firstnam, lastname, city, state, that sort of thing. It then presents any fields with names like that in its standard sequence. However, as far as I am aware, if you do not name any of your fields that way, it will either sequence them in alpha order or their sequence in the query/table. So I would name my fields something like "01 the first column name" "02 thesecond column name" and so on. If you can't start with a digit, use e.g. "A1 the first column name" "A2 the second column name" and so on. -- Peter Jamieson http://tips.pjmsn.me.uk "helios" wrote in message ... Does this help? The mailmerge query is based on a union query which pulls together data from seven queries. (Please--I know, but this is an inherited database and I have no time to overhaul the data management.) Is the order perhaps a prioritized conglomeration of field order in one or all of the query levels? I'll see if I can make any sense of it. "helios" wrote: Word 2003/Access 2003 (Access 2000 database format) I have a mailmerge linked to an Access query. It allows the user to select invitees using the "Select Recipients" utility. However, I can't seem to figure out how to make certain fields show up in the first few columns of the query records list. This makes it difficult to quickly scan and select certain recipients from the list without first shrinking the width of the columns that don't identify the recipient (i.e. name, type, event, etc.). I have tried reordering the columns in the query design view (matches SQL order), in the datasheet view. I have the query sorted on three fields (one is calculated), if that matters. None of this seems to have any bearing on the order of the fields in the "Mail Merge Recipients" window! How can I get the fields to show up in my preferred order?! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
email merge with multiple recipients in "To", "CC" & "BCC" | Mailmerge | |||
Can you change the order of tabs in "Format Picture" command? | Microsoft Word Help | |||
Looking for "change order" template for contract project work | Microsoft Word Help | |||
why does "select table" come up when I am selecting recipients? | Mailmerge | |||
how to change the order of prompting of "fill-in" fields? | Microsoft Word Help |