OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Mail Merge

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Writer
View previous topic :: View next topic  
Author Message
Bravoich
General User
General User


Joined: 16 Mar 2004
Posts: 13

PostPosted: Sun Mar 28, 2004 7:20 pm    Post subject: Mail Merge Reply with quote

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
View user's profile Send private message
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Mon Mar 29, 2004 5:39 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Writer All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group