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 - 19 Jul 2006 19:35 GMT
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
> How can I combine StretNum + space + StretNam into one mail merge field?
>
[quoted text clipped - 5 lines]
>
> Many thanks in advance, Joe
Doug Robbins - Word MVP - 19 Jul 2006 19:39 GMT
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.

Signature
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
> How can I combine StretNum + space + StretNam into one mail merge field?
>
[quoted text clipped - 5 lines]
>
> Many thanks in advance, Joe