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
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