Have a textbox which finds the first empty row and enters name in column A. Lookup pulls the corresponding e-mail into column C.

Having issues sending an email to address in column c.

Am trying to use name with code newmsg.recipients.add(TextBox1.Value) but that creates a conflict so want to avoid names and go direct to address. This action is always going to be in the last row.


Another part is:

1. Have job number in column B. When completed job number is scanned and email needs to be sent to corresponding address in Column C. This might not necessarily be the last row in the sheet. The code has to find the corresponding address and send it.

Have been busting my brains but cannot locate how to do it. Can send emails to static addresses but this pfftt!