Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DotNet Data Table as Mail Merge Data Source | Mailmerge | |||
How to create a data file with addresses to merge form letter docu | Mailmerge | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
Mail merge error occurs when filtering Excel data source | Mailmerge | |||
Merge Data Source path | Mailmerge |