Dogs Body

Hi

Im trying to format a cell with nested IF conditions that will instantiate a mail.

I have columns including surname, firstname, DOB, Grade and a drop list.

The idea is to select a person from dropdown list. A cell on the row when clicked will check the condition of the selected person, address the mail to that person, pick up the information from the row, open an email and place the concatenated information in the body text

I’m trying to do this within nested IF conditions (5) and using the HYPERTEXT mailto function.

Hypertext mailto allows the subject field to be populated with set information/text. 

I cant get anything to work.

Any ideas?

Apologies, I dont know how to upload the data on here so have pasted below. Not very clear unfortunately.

Many thanks

Assist Date Surname FirstName DOB Grade Senior    
23.08.17 Worker  One 23.02.39 Grade 1 Person1   IF(AND(OR(G10=”Please Select”,”Select mail”,IF(G10=”Person1″,I10=Data!B12,IF(G10=”Person2″,I10=Data!B12,IF(G10=”Person3″,I10=Data!B12,IF(G10=”Person4″,I10=Data!B12,IF(G10=”Person5″,I10=Data!B12,)))))
26.08.17 Worker  Two 30.11.34 Grade4 Please select   IF(G11=”Please Select”,”Select Mail”,IF(G11=”Person1″,=HYPERLINK(“mailto:Person1@someaddress.com,?subject=Your Assitant for this day is below”, &body=(Action!C11&” “&Action!D11).“, “Select mail”)))
05.08.17 Worker  One 06.01.61 Grade 1 Please select   =HYPERLINK(“mailto:mike@someaddress.com?subject=Email To DataPig”, “Send Email”)
06.08.17 Worker  Three 04.11.42 Grade 3 Please select    
09.08.17 Worker  One 23.02.39 Grade 1 Please select    
11.08.17 Worker  Two 30.11.34 Grade4 Please select    
12.08.17 Worker  One 06.01.61 Grade 1 Please select    
13.08.17 Worker  Three 04.11.42 Grade 3 Please select    

By: AJ

Leave a Reply

Your email address will not be published. Required fields are marked *