OK, so I'm trying to do a simple mail merge... or so I thought...
My data was given to me in the following format
[name first] [name last] [address 1] [address 2] [city] [state] [zip] (in an excel document)
Easy enough...
My Question:
I want the data to show up like this
[name first] [name last]
[address 1]
[address 2]
[city] [state] [zip]
example
Joe Blow
123 Willow Road
Apartment 4C
Washington, DC 22222
That's the easy part. [b]But what happens when there is no data in the [address 2] field?
I get:
Joe Blow
123 Willow Road
Washington, DC 22222
I can't find a way to "hide" the [address 2] blank info!!!!
I could really use some help on this one.
Top
