Jump to content

customised letter layout


simpleassid
 Share

This topic is 5784 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hello all,

Have been a "lurker" for a while, and found all the answers to my questions, however i cant find any clues on this one...

What I am trying to do is create a letter that is personalised with information that is not directly in my database, for example; in the database i have a field that contains a partners name, if this is filled in there are additional paragraphs i need to include that relate to married couples, i've thought about using different layouts but there so many variables i would need about 20 diffenerent layouts,

what i need is an IF calculation that populates perhaps a merge field with data that is stored somewhere else?

i'm a bit confused and i'm sure anyone reading this is also!!!

Simon

Link to comment
Share on other sites

Simon you're already on the right track. Put the optional text into a series of fields. If you only have a few paragraphs then they could go into global fields. If you have lots of these variable paragrapsh then it would be better to put them into their own table. That way it would be completely flexible if you need to add other optional text in the future. Make sure that each record has it's own Record number or a name to identify it. Then you make a field which is called Text for lack of a better name and make it a calculation field = "Starting Text" & If(Not IsEmpty(Partner);Partner Text Field; "") & so on where "Starting Text" is the field containing the starting text. You'll want to put carriage returns in this as well and they may have to be calculations as well to get the proper spacing. ie) if partner is not empty then you'll want to put in a carriage return but if it's empty you won't. Is this enough of a help to get started? JJ

Link to comment
Share on other sites

This topic is 5784 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.