Sendmail

  • Thread starter Mattlynn via OfficeKB.com
  • Start date
M

Mattlynn via OfficeKB.com

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
 
M

Mattlynn via OfficeKB.com

R

Ron de Bruin

This is a bit confusing for me.

Why do you need sheet arrays ?

You can use
http://www.rondebruin.nl/mail/folder1/mail5.htm

Or a sheet template
http://www.rondebruin.nl/mail/templates.htm

If I not understand you correct post back with exactly what you want to do.
I will reply this evening because I must go now




--

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


Mattlynn via OfficeKB.com said:
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

Hi Matt

Try to use a range, see
http://www.rondebruin.nl/mail/tips1.htm
Hi all
I have a sendmail Macro.
Click to expand...
[quoted text clipped - 7 lines]
Many Thanks
Matt Lynn
Click to expand...
Click to expand...

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/200808/1
Click to expand...
 
Top