[Jay Silver]

How can I combine StretNum + space + StretNam into one mail merge field?

LstNam,FrstNam,StretNum,Unknwn,StretNam,Apt,AptNum ,City,St,Zip1,Zip2
Bonia,Emily,400,,Bridle Path Rd,APT,TH19,Bethlehem,PA,18017,3153
Bouton,Sharon,400,,Bridle Path Rd,APT,T,Bethlehem,PA,18017,3148
England,Pamela,400,,Bridle Path Rd,APT,C6,Bethlehem,PA,18017,3145
MacAdam,Markr,400,,Bridle Path Rd,APT,B7,Bethlehem,PA,18017,3146

Many thanks in advance, Joe

[Peter Jamieson]

Well, you can only combine them into one field by changing the data source
(or the query used to get the data).

To display them, all you need is

{ MERGEFIELD Stretnum } { MERGEFIELD Stretnam }

To combine them into a single /thing/ that you can re-use, you can use

{ SET myfield "{ MERGEFIELD Stretnum } { MERGEFIELD Stretnam }" }

then e.g.

{ REF myfield }

If you need to test the combined fields in an IF or COMPARE field, you can
then either use

{ IF "{ MERGEFIELD Stretnum } { MERGEFIELD Stretnam }" = "something"
"true" "false" }

or

{ IF "{ REF myfield }" = "something" "true" "false" }

Peter Jamieson
"Jay Silver" Jay wrote in message
...
How can I combine StretNum + space + StretNam into one mail merge field?

LstNam,FrstNam,StretNum,Unknwn,StretNam,Apt,AptNum ,City,St,Zip1,Zip2
Bonia,Emily,400,,Bridle Path Rd,APT,TH19,Bethlehem,PA,18017,3153
Bouton,Sharon,400,,Bridle Path Rd,APT,T,Bethlehem,PA,18017,3148
England,Pamela,400,,Bridle Path Rd,APT,C6,Bethlehem,PA,18017,3145
MacAdam,Markr,400,,Bridle Path Rd,APT,B7,Bethlehem,PA,18017,3146

Many thanks in advance, Joe

[Doug Robbins - Word MVP]

There is no reason to combine them into one merge field. Just insert the
merge fields in the configuration that you want them. That is with a space
between.

If you really want to combine them, open the datasouce in Excel and then use
a formula in Excel to combine them.

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

"Jay Silver" Jay wrote in message
...
How can I combine StretNum + space + StretNam into one mail merge field?

LstNam,FrstNam,StretNum,Unknwn,StretNam,Apt,AptNum ,City,St,Zip1,Zip2
Bonia,Emily,400,,Bridle Path Rd,APT,TH19,Bethlehem,PA,18017,3153
Bouton,Sharon,400,,Bridle Path Rd,APT,T,Bethlehem,PA,18017,3148
England,Pamela,400,,Bridle Path Rd,APT,C6,Bethlehem,PA,18017,3145
MacAdam,Markr,400,,Bridle Path Rd,APT,B7,Bethlehem,PA,18017,3146

Many thanks in advance, Joe