Good Morning All,

I'm trying to write a macro to split the contents of a cell when the contents are separated by a semicolon ;

This is for an automatic e-mail macro, the cell I'm trying to split contains the names of people previously e-mailed, like so. Bob Johnson; Michael Faraday

I'd like to split the names up and then search each name on another sheet and return their e-mail address.

I found the below, which splits the contents of cells into more cells.

http://www.excelforum.com/excel-prog...-at-every.html

Any help or advice would be greatly appreciated.

R