hi,

Try changing your ".recipients..." to
Code:
--------------------
.to
--------------------


There are lots of examples on Ron's site, 'Example Code for sending
mail from Excel' (http://www.rondebruin.nl/sendmail.htm), including this
one, 'Tips for the Outlook object model examples'
(http://www.rondebruin.nl/mail/tips2.htm), which shows ".recipients.add"
being used for adding a distribution list.

hth
Rob


--
broro183

Rob Brockett. Always learning & the best way to learn is to
experience...
------------------------------------------------------------------------
broro183's Profile: http://www.thecodecage.com/forumz/member.php?userid=333
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=99416