Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2003 Merge fields
How can I reorder merge fields so that when I click to use Data Form view,
then click Find, the Find in Field popup box shows my desired field (which is always the 1st field in the table) in the In Field box, vs clicking on the dropdown to select it? Currently my desired field is the 3rd field in my table, not the first. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2003 Merge fields
As far as i can tell, the sequence of coulumns in the Data Form view itself
is determined by Word, but the sequence in the drop-down is the same as the sequence in the data source, so in principle you can change the sequence of columns in your data source. If your data source is a standard "Office Address List" that you created during mailmerge, I do not think you will be able to do this without causing problems. if your data source is an Access or SQL Server table etc. you might be able to create a Query/View which listed all the columns in the order you want, and use that as the data source (I haven't tried). Or for some data sources you could try opening he data source in VBA and listing the fields in the order you need in the SQL SELECT statement. Peter Jamieson "Malin" wrote in message ... How can I reorder merge fields so that when I click to use Data Form view, then click Find, the Find in Field popup box shows my desired field (which is always the 1st field in the table) in the In Field box, vs clicking on the dropdown to select it? Currently my desired field is the 3rd field in my table, not the first. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2003 Merge fields
You can rearrange the order of your columns in the Mail Merge Recipients
dialog box. Click on the third box (with the pencil) in the M.M. Toolbar. Then just drag 'em where you want 'em. "Peter Jamieson" wrote: As far as i can tell, the sequence of coulumns in the Data Form view itself is determined by Word, but the sequence in the drop-down is the same as the sequence in the data source, so in principle you can change the sequence of columns in your data source. If your data source is a standard "Office Address List" that you created during mailmerge, I do not think you will be able to do this without causing problems. if your data source is an Access or SQL Server table etc. you might be able to create a Query/View which listed all the columns in the order you want, and use that as the data source (I haven't tried). Or for some data sources you could try opening he data source in VBA and listing the fields in the order you need in the SQL SELECT statement. Peter Jamieson "Malin" wrote in message ... How can I reorder merge fields so that when I click to use Data Form view, then click Find, the Find in Field popup box shows my desired field (which is always the 1st field in the table) in the In Field box, vs clicking on the dropdown to select it? Currently my desired field is the 3rd field in my table, not the first. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2003 Merge fields
Thanks. Unfortunately, as far as I can tell, the new sequence is not
preserved, i.e. the next time you open the Recipients box, the sequence is reset to the one determined by Word. Do you experience something else? Peter Jamieson "Recorder" wrote in message news You can rearrange the order of your columns in the Mail Merge Recipients dialog box. Click on the third box (with the pencil) in the M.M. Toolbar. Then just drag 'em where you want 'em. "Peter Jamieson" wrote: As far as i can tell, the sequence of coulumns in the Data Form view itself is determined by Word, but the sequence in the drop-down is the same as the sequence in the data source, so in principle you can change the sequence of columns in your data source. If your data source is a standard "Office Address List" that you created during mailmerge, I do not think you will be able to do this without causing problems. if your data source is an Access or SQL Server table etc. you might be able to create a Query/View which listed all the columns in the order you want, and use that as the data source (I haven't tried). Or for some data sources you could try opening he data source in VBA and listing the fields in the order you need in the SQL SELECT statement. Peter Jamieson "Malin" wrote in message ... How can I reorder merge fields so that when I click to use Data Form view, then click Find, the Find in Field popup box shows my desired field (which is always the 1st field in the table) in the In Field box, vs clicking on the dropdown to select it? Currently my desired field is the 3rd field in my table, not the first. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does Word have a QuickCorrect/Quick Word option like WordPerfect? | New Users | |||
In Word, how do I surpress headers and footers on page 2 | Microsoft Word Help | |||
Insert merge fields - Word 2003 | Mailmerge | |||
In Word, how can I see all files (*.*) in "save as"? | New Users | |||
How to change merge forms from Word Perfect to Microsoft Word | Microsoft Word Help |