Hi MiNK

Which mail program do you use ?


--

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


"MiNK" wrote in message ...
Hello

I am trying to pull together an email from within Excel and can do so
successfully. I gather various pieces of data from various worksheets,
collate them and add them to the email.

However I am coming across a slight problem. Data such as email address etc.
is no problem. When trying to create the main body of the email I pull data
from the worksheets and place it within a variable.

The problem is that at some point the data I pull into the variable must
become too large.

The code is something like:

loop for each valid cell
msg = msg & cell value & crlf
next loop

Once all the data is collected, I replace all spaces with %20, then replace
all carriage returns with %0D%0A.
I believe that msg (variant) is too full. I say this because my routine
works OK if I pull together 43 sets of data, but fails with 44 and above.

I copied the data to a cell on my worksheet and did len(cell). With 43 =
1925, with 44 = 1947.

Is there a limit to the data length for a variant (or string) variable? Is
there a limit on the amount of data on an email.

Any help would be appreciated.

Regards
MiNK