login about faq

Hi,

I have copied pasted text from https://www.example-code.com/sql/mht_emailWebPage.asp

But I get a blank email..

Please help!

asked Dec 10 '16 at 08:10

smokey's gravatar image

smokey
1


It's likely the string returned by the mht.GetEml method is longer than 4000 chars.

    DECLARE @emlStr nvarchar(4000)
    EXEC sp_OAMethod @mht, 'GetEML', @emlStr OUT, 'http://www.bonairefishing.com/'

See if you can declare the nvarchar larger. If not, then Chilkat is making a note to add alternative methods to return the string in a Chilkat.StringBuilder object instead. This will eliminate the issues with long strings in SQL. The new version that includes this new method will be out in a few weeks. I can provide a pre-release with sample prior to that, but not immediately because of other unrelated work that needs to be finished first..

(It is also possible to get string results in a temp table..)

link

answered Dec 12 '16 at 09:23

chilkat's gravatar image

chilkat ♦♦
12.8k318385543

Thanks for your answer.

I tried varchar(8000) and infact the same page http//www.bonairefishing.com did not work.

Now I am loading it as EML and then sending it.

link

answered Dec 12 '16 at 09:33

smokey's gravatar image

smokey
1

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or __italic__
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×21
×8

Asked: Dec 10 '16 at 08:10

Seen: 703 times

Last updated: Dec 12 '16 at 09:33

powered by OSQA