Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

If/then


surlyb

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

Recommended Posts

I recently inherited a database from a third or fourth party. It is a 700 strong database of names and addresses. It has fields for name, work address, work address 2, work city, work state, work zip, mailing address, mailing address city, mailing address state, mailing address zip. While everyone on the list has one address, not everyone has the two, and in some cases the mailing address and work address is the same. I need to send a letter to all the names. Is there any way to set up an if/then statement, so that if one address exists (i.e work), the letter will be addressed to that one, and ignore the other, and vice versa? If no work address exists it will select the mailing address, and if the two addresses are the same that only one will be selected?

Link to comment
Share on other sites

You'll need to add another field (addressPrint.calc) just for the printed address:

addressPrint.calc : Case(IsEmpty(workAddress), homeAddress & "P" & homeCity & " " & homeState & " " & homeZip, workAddress & "P" & workCity & " " & workZip)

The "P" is a paragraph return, and I'm sure the names of the fields woudl need to be corrected. The above is set to print the work address first, and if no work address, then the home address. To reverse this, just change the IsEmpty test to be the homeAddress field and then reverse the names beteen work and home fields.

Link to comment
Share on other sites

This topic is 8543 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
×
×
  • Create New...

Important Information

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