Hi,

I have the following code

Please Login or Register  to view this content.
Please let me know if I got this correct - The "TO" address will appear in column B, thus this is the cell.value. If a have an address in column AP for the "CC" is my statement above correct. Oh and column B will work on a IF formula looking at a different, i.e. IF(AJ11="";"";e-mail address based on a vlookup linked to a user from a pick list

Thank you