Reply
 
Thread Tools Display Modes
  #1   Report Post  
MCStuff
 
Posts: n/a
Default merge data w/two addresses only using one if other is empty

I have a standard envelope to merge data from excel worksheet that has two
addresse fields, Property Address and Mailing Address, I need to have the
Mailing Address to print on envelope, but if that field is blank, need the
Property
Address to print. I tried to use the Insert Word Field, but the If Then
Else feature does not work. Also how do I turn on and off the toggle codes?
  #2   Report Post  
Doug Robbins - Word MVP
 
Posts: n/a
Default merge data w/two addresses only using one if other is empty

Use Alt+F9 to toggle the display of field codes

{ IF { MERGEFIELD MailingAddress } "" { MERGEFIELD MailingAddress} {
MERGEFIELD PropertyAddress } }

where you use Ctrl+F9 to insert each pair of field delimiters { }

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

"MCStuff" wrote in message
...
I have a standard envelope to merge data from excel worksheet that has two
addresse fields, Property Address and Mailing Address, I need to have the
Mailing Address to print on envelope, but if that field is blank, need the
Property
Address to print. I tried to use the Insert Word Field, but the If Then
Else feature does not work. Also how do I turn on and off the toggle
codes?



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
DotNet Data Table as Mail Merge Data Source goraya Mailmerge 1 July 7th 05 09:51 AM
How to create a data file with addresses to merge form letter docu GTDriver Mailmerge 2 June 11th 05 04:00 AM
Specific Email Merge w/ Specific Attachements Mark B Mailmerge 9 February 21st 05 05:10 AM
Mail merge error occurs when filtering Excel data source Dave Mailmerge 1 December 2nd 04 10:46 PM
Merge Data Source path Peter Jamieson Mailmerge 0 November 25th 04 07:15 PM


All times are GMT +1. The time now is 03:50 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"