Hi Matt

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Mattlynn via OfficeKB.com" <u44078@uwe wrote in message news:885b7d209017f@uwe...
Hi all
I have a sendmail Macro.
I need to add about 47 sheet arrays, and 47 emails addresses. When i get to
about 30 email addresses, all the text goes red.
I am assuming its becuase there are too many characters.

Can i increase the allowed number of characters, or is the Red text meaning
something else.

Many Thanks
Matt Lynn

--
Matt Lynn

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