Email Generation
 

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

Email Generation
 

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

Email Generation
 

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

"Ron de Bruin" wrote in message
...
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

Email Generation
 

You can use other code then

See the Outlook object model (body) section
http://www.rondebruin.nl/sendmail.htm




--

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


"MiNK" wrote in message ...
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

"Ron de Bruin" wrote in message
...
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