Im having this issue with one system not communicating with another so I wanted to do a mass update of the other system. What I need your assistance with is compiling an email to the customer that will have two formulas with the the blue chart information to overwrite the yellow chart infomation.
The AP email 1 is the only to email and then the AP secondary email/s first as the cc contact and then any primary contacts cc'd as 2nd, 3,rd, 4th etc.
The AP email 1 is the only to email and then the AP secondary email/s first as the cc contact and then any primary contacts cc'd as 2nd, 3,rd, 4th etc.
Test.xlsx | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |||
1 | SF | Customer ID | Customer Name | Contract Name | Primary Email #1 | Secondary Email #2 | email contact 1 | email cc contacts | Sage | customer id | account name | ap secondary | ap contact | primary contact | ||||||
2 | 1 | cranberry | cranberry grad | ap@gmail.edu | mhovis@gmail.com | ? | ? | 1 | cranberry grad | ap@gmail.edu | TRUE | FALSE | ||||||||
3 | 2 | dover | dover college | xyz@Gmail.com | ? | ? | 1 | cranberry grad | mhovis@gmail.com | FALSE | TRUE | |||||||||
4 | 3 | quest | quest college | abc@gmail.com | ? | ? | 1 | cranberry grad | ajloverboy@gmail.com | char@gmail.com | FALSE | TRUE | ||||||||
5 | 4 | quest | quest college | ap@quest.edu | 2 | dover college | accountspayable@dover.edu | TRUE | FALSE | |||||||||||
6 | 3 | quest college | ap@quest.edu | FALSE | TRUE | |||||||||||||||
7 | 3 | quest college | ap@quest.edu | TRUE | FALSE | |||||||||||||||
8 | 3 | quest college | apiii@quest.edu | aaaaa@gmail.com | FALSE | TRUE | ||||||||||||||
Sheet1 |