Goldmine Lookup.ini Tip
by JR Fent - February 2005
Copying names of two people to the Dear field automatically.
Home

I have a few clients that enter couples into their Goldmine database.  So the Primary contact could be JR & Connie Fent.  The issue becomes sending them a mail merge letter or email – so here is a script that will take the two first names of the people and put it into the Dear field…

 

--------------------------------------------------------------------------------------------------

[AutoUpdate]
NewRecord=Dear
Contact=Dear

- **** This lookup.ini created by Anthem Consulting - www.anthemweb.com *****

[Dear]
lookup1=Contact
" "=" "
otherwise=&IIF("&" $ contact1->contact, word(contact1->contact,1)+ " & "+ word(right(contact1->contact,39-at("&",contact1->contact)),1) , word(contact1->contact,1))
overwrite=1

 

 

This puts the first name in the Dear field AND IT puts 2 first names in the dear field if you are entering a couples name. ie - JR & Connie Fent in the contact field will put "JR & Connie" into the Dear field.
Absolute News Manager : news publishing software and web content management system by Xigla Software

The article has been moved here