Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / July 2006

Tip: Looking for answers? Try searching our database.

How do I combine 2 data fields into one merge field in WORD 2003?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jay Silver - 19 Jul 2006 19:10 GMT
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

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.