Sending Email To Recipients From One Cell?

[funksta]

Hi,

I need to email a workbook to several people. I have all the recipients in a textfile and have pasted that into a cell on my workbook (B:15) in the format name1@address1.com; name2@address2.com

Is there a way I can point the recipients part of Excel's sendmail to B15 and have it use that or do I have to put them into an array?

If I have to use an array please can someone give me guidance on how to achieve this?

thanks

Dave

 

[martinee]

I'd use text to columns to split the e-mail addresses. Use delimited, semi-colon and space, treat consecutive delimiters as one. HTH.