| View previous topic :: View next topic |
| Author |
Message |
Bravoich
General User
Joined: 16 Mar 2004
Posts: 13
|
 Posted: Sun Mar 28, 2004 7:20 pm Post subject: Mail Merge |
 |
|
Hi! I have a problem regarding mail merge in open office 1.1, I have 3 fields ADD1, ADD2, and ADD3. but, what if in my data source some records in field ADD2 has no data? Example in 1 record ADD1 and ADD3 has a data but in ADD3 has no data… and this is my format mail template…
<ADD1>
<ADD2>
<ADD3>
so when I press the button data to field… it goes like this
1234 Gjdorklt st.
<blank>
Malaysia
Is there is a way to make it automatically adjust the field ADD3 to ADD2 if the field ADD2 has no data in my data source? |
|
| Back to top |
|
 |
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8976
Location: Lexinton, Kentucky, USA
|
| Posted: Mon Mar 29, 2004 5:39 am Post subject: |
|
|
After <ADD2> insert the Hidden Paragraph field with the Condition set to ADD2 EQ "". The Hidden Paragraph function is found at Insert > Fields > Other > Function tab.
To handle something like <First> <Middle> <Last> set it up as:
<First> <Middle><Hidden Text><Last> with the condition set to Middle EQ "" and the text as a space, i.e., hid a space unless Middle contains something. |
|
| Back to top |
|
|
|
