No, I tried your code before I sent the Email. It works fine on my machine
with the Note DataType. You may have other problems.
Why don't your try this setup putting your header stuff in the EED var first
then adding the rest to it. It could be something like stack space on the
machine you are working on assigning a var type Note to another var type
Note for a total of 8k of space in two vars. Since you were having no
trouble up to that point, I would have reason to believe the following would
work.
SET QUOTES = '
SET VAR eet NOTE = '[EMAIL PROTECTED]'
SET VAR ees NOTE = 'THIS IS THE SUBJECT LINE'
SET VAR eec NOTE = 'THIS IS THE CARBON COPY TO'
SET VAR eeb NOTE = 'THIS IS THE BLIND CARBON TO LINE'
SET VAR eed NOTE = ('mailto:'+.eet+'?subject='+.ees+'&cc='+.eec+ +
'&bcc='+.eeb+'&body=')
SET VAR eed NOTE = (.eed + 'THIS IS THE #1 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #2 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #3 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #4 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #5 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #6 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #7 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #8 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #9 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #10 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #11 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #12 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #13 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #14 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #15 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #16 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #17 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #18 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #19 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #20 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #21 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #22 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #23 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #24 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #25 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #26 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #27 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #28 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #29 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #30 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #31 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #32 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #33 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #34 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #35 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR eed NOTE = (.eed + 'THIS IS THE #36 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
*(the below gives the length of the body)
SET VAR A INTEGER = (SLEN(.eed))
pause 3 using .A AT center center
LAUNCH .eed
----- Original Message -----
From: Lee Bailey
To: [EMAIL PROTECTED]
Sent: Monday, November 19, 2001 2:36 PM
Subject: Re: Launching Emails
Mike-
If VEMAIL is changed to a note field in order to get all of the assembled
sentences, the message "RBG65 has caused an error in Kernal32.dll" appears--
and we are cooked.
The body size must exceed that of a text field to see the error. If you use
a small body size (example: 2 sentences) it will work just fine.
Please try the below code, and see if you get the same result that I got.
Lee Bailey
Bailey & Associates
E-Mail: [EMAIL PROTECTED]
Phone: 954-659-1780
Fax: 954-659-1781
----- Original Message -----
From: MikeB
To: [EMAIL PROTECTED]
Sent: Monday, November 19, 2001 1:46 PM
Subject: Re: Launching Emails
Lee,
Your SET VAR VEMAIL TEXT = +
('mailto:'+.EET+'?subject='+.EES+'&cc='+.EEC+'&bcc='+.EEB+'&body='+.EED)
won't fly. You are trying to set a variable of type TEXT equal to a string
of over 2700 char length. A TEXT datatype is limited to 1500 chars. Set it
to a NOTE datatype.
SET VAR VEMAIL NOTE = +
('mailto:'+.EET+'?subject='+.EES+'&cc='+.EEC+'&bcc='+.EEB+'&body='+.EED)
Will Do It.
----- Original Message -----
From: Lee Bailey
To: R-Base Answers
Sent: Monday, November 19, 2001 12:21 PM
Subject: Launching Emails
Hello All-
I've still got a problem that I am hoping someone will be able to help with.
The below code, although lengthy and absurd, is very simple and shows the
issue. The entire code string simply generates an email message in
Microsoft Outlook. EET, EES, EEC, and EEB generate the "to:", "Subject
line", "Carbon copy", and "blind carbon copy" respectively for the email.
This part works fine.
EED just assembles a number of sentences to form the body of the email.
If you cut and paste the code at the R> prompt, you should be able to obtain
the same results that I have found.
If VEMAIL is left as a text field, the email will generate normally, but the
body of the text will be abbreviated, as one would expect from a finite
length for a text field.
If VEMAIL is changed to a note field in order to get all of the assembled
sentences, the message "RBG65 has caused an error in Kernal32.dll" appears--
and we are cooked.
"A" is nothing more than counting the text characters in the body string.
The count is actually 2979 characters-- well within the scope of the
typical note field maximum of 5000 characters.
SET QUOTES = '
SET VAR EET NOTE = '[EMAIL PROTECTED]'
SET VAR EES NOTE = 'THIS IS THE SUBJECT LINE'
SET VAR EEC NOTE = 'THIS IS THE CARBON COPY TO'
SET VAR EEB NOTE = 'THIS IS THE BLIND CARBON TO LINE'
SET VAR EED NOTE = 'THIS IS THE #1 SENTENCE IN THE PARAGRAPH THAT WILL +
APPEAR IN THE BODY OF THE EMAIL'
SET VAR EED NOTE = (.EED + 'THIS IS THE #2 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #3 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #4 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #5 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #6 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #7 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #8 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #9 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #10 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #11 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #12 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #13 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #14 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #15 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #16 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #17 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #18 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #19 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #20 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #21 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #22 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #23 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #24 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #25 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #26 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #27 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #28 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #29 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #30 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #31 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #32 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #33 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #34 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #35 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
SET VAR EED NOTE = (.EED + 'THIS IS THE #36 SENTENCE IN THE PARAGRAPH THAT +
WILL APPEAR IN THE BODY OF THE EMAIL')
*(the below gives the length of the body)
SET VAR A INTEGER = (SLEN(.EED))
WRITE .A AT 10,10
SET VAR VEMAIL TEXT = +
('mailto:'+.EET+'?subject='+.EES+'&cc='+.EEC+'&bcc='+.EEB+'&body='+.EED)
LAUNCH .VEMAIL
Give it a try. I appreciate any help.
Lee Bailey
Bailey & Associates
E-Mail: [EMAIL PROTECTED]
Phone: 954-659-1780
Fax: 954-659-1781
