bulletshiva
New Member
- Joined
- Jun 6, 2018
- Messages
- 11
Hello,
I have a task to send mail to the person responsible based on the dept code with the part number.
Each alphabet has a dept associated.
For example letter "K" is a dept and the contact is example@gmail.com. The critical part is that all the letters are in a single cell. Need help to create a macro with such a case.
Also copy part numbers to e-mail related to a dept as one e-mail.
<colgroup><col><col></colgroup><tbody>
</tbody>
I have a task to send mail to the person responsible based on the dept code with the part number.
Each alphabet has a dept associated.
For example letter "K" is a dept and the contact is example@gmail.com. The critical part is that all the letters are in a single cell. Need help to create a macro with such a case.
Also copy part numbers to e-mail related to a dept as one e-mail.
| Part Number | Responsible dept |
| A001.345.234 | KCVEDPAFLSQBGXZ |
| A001.345.235 | KCVEDPAFLSQBGXZ |
| A001.345.236 | KCVEDPAFLSQBGXZ |
| A001.345.237 | KCVEDPAFLSQBGXZ |
| A001.345.238 | KCVEDPAFLSQBGXZ |
<colgroup><col><col></colgroup><tbody>
</tbody>
