Email Generation

  • Thread starter Thread starter MiNK
  • Start date Start date
M

MiNK

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

We're using Outlook.
In fact I need to use 2 different approaches to the emails. One for just the
email, the other if there's an attachment. I'm looking at this at the moment
to see if I can use just one email routine. Any suggestions?

Cheers

MiNK
 
Back
Top