Hello, I am writing a letter that has two drop down fields. Depending on the item selected it references another section of the letter to automatically input data.
i.e in my letter you select the employee's name (dropdown2) and company (dropdown 1) and then it will prepopulate their email. Most employees are First.Last@companya, First.Last@companyc and First_Last@companyb however; one employee "Donald Duck" is First.Last for all three companies. Does anyone know what code I need to type for this?



The code I am currently using is:
{if{ Dropdown2}= "Mickey Mouse""Mickey"""}{if{ Dropdown2}= "Minnie Mouse""Minnie"""}{if{ Dropdown2}= "Donald Duck""Donald"""}{if{ Dropdown1}= "Company B""_""""}{if{ Dropdown1}= "Company A""."""}{if{ Dropdown1}= "Company C""."""}{if{ Dropdown2}= "Mickey Mouse""Mouse"""}{if{ Dropdown2}= "Minnie Mouse""Mouse"""}{if{ Dropdown2}= "Donald Duck""Duck"""}"""}{if{ Dropdown1}= "Company B""@companyb.com""""}{if{ Dropdown1}= "Company A""@companya.com."""}{if{ Dropdown1}= "Company C""@companyc.ca"""}

any suggestions?

Attached Files

TEST No personal data letter.docx (14.3 KB, 12 views)