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 / November 2004

Tip: Looking for answers? Try searching our database.

Merging Data in Word

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jim Imrie - 06 Nov 2004 19:47 GMT
My data has a PO box address and an actual address when PO box address is not
available it is marked NA and visa versa. How do I get the merge to use the
PO box when available and the actual address when available?
macropod - 07 Nov 2004 01:50 GMT
Hi Jim,

In that case, use an IF test to determine which MERGEFIELD to use. For
example:
{IF{MERGEFIELD PO_Box}= "NA" {MERGEFIELD Address} {MERGEFIELD PO_Box}}
Of course, you'll need to decide which address to use if you've got both
(the above gives precedence to the PO Box), and you might also need to allow
for both the PO box and the actual address to span more than one line.

Cheers

> My data has a PO box address and an actual address when PO box address is not
> available it is marked NA and visa versa. How do I get the merge to use the
> PO box when available and the actual address when available?
 
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.