Hi Ron
This is a bit confusing for me.
How will this work when sheet 1 goes to person 1, sheet 2 to person 2 etc.
Do i need 2 ranges , one for sheet arrays and one of corresponding email
addresses ??

Thanks very much for your help.
Matt


Ron de Bruin wrote:
Hi Matt

Try to use a range, see
http://www.rondebruin.nl/mail/tips1.htm

Hi all
I have a sendmail Macro.
[quoted text clipped - 7 lines]
Many Thanks
Matt Lynn

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200808/1