1)I am seeking the formula for If/Then to include multiple options and results. Effectively: (If 1,2 or 3 then A), (If 4,5 or 6 then B), (If 7,8 or 9 then C). This is a cell format that is reading another cell where one of 1-9 are selected.

2)We have generated a macro to initiate a new email but are lacking 3 things:
a) Getting the worksheet in the body of an outlook email.
b) Title of worksheet in Excel cell inserted as Subject of email.
c) CC the sender.

Thank you in advance for any help.