I have written a Macro that transfers data from and input sheet into a data collection table. On the click of the button, the data is transferred to a new row, the input sheet it cleared, the workbook is saved and I receive an email notification to say that new information has been added to the sheet.
I would like to know how to get the email notification to go to different people depending on the contents of a cell.
For example,
I have a merged cell (B9:C10) that details from which department action is required (Operations, Engineering or Quality).
How do I adapt my code so if the cell = “Operations” it sends the email to PERSON A
If the cell = “Engineering” it send the email to PERSON B etc etc.
My current email code is as follows:
Please help.
Thanks
Bookmarks