Hi folks!

I'm playing with an upgrade to be able to email out merge docs as HTML content rather than our current process of using merge programming, pull up the doc in MS Word, Print to PDF, and save it as an attachment.

My first step is using MergeFilePrint to create an HTML output -- and I am almost able to do so -- however, the merge content I am trying to include (DBName) is not populating.   It is creating an output file (which is great), but no file data appears.  Am I doing anything wrong, or do I need to do "DR Screen Lite!DBName" instead of "DBName"?

MergeFilePrint("s:\Docs\DB\LAATEST2.HTM","HTM","","","DBName=DBName","s:\Docs\DB\200664B", 0)
 

That helps ... thanks!

So I'm slowly building up an HTML template, and when I try to add fields, I start getting the following output ...

Example Text 3

class=SpellE>LTTRName]]
 

What is that class=SpellE> error and how can I eliminate that?  I'm currently building the HTML document in Word 10, and saving as HTML ...

Perfect ... thanks.  I acknowledge my limitations with HTML and after I went to my customer service manager and made her cry, she will try to open it in a real HTML editor and look at it.

Next question -- while it's creating bad import data, I've moved ahead to try to send out the HTML in an email, and it's failing -- when I send an email without the attachment, it goes fine, but when I put vOutputFile in my @sendmail command, nothing is received by the recipient.  Examples on the Lantica boards suggest I'm doing this right -- am I missing something?

Here's my code thus far ...

var vOutputFile as string
var n as int
var vTitle as string
var vMessage as string
var vServerdate as string = @serverdate()
var vDate as string

vDate = @Dow$(vServerdate) + ", " + @month$(vserverdate) + " " + @dom(vServerdate) + ", " + @year(vServerdate)

vOutputFile = "S:\Docs\DB\" + DBID + "-ELA-" + @num(@serverdate()) + "-" + @num(@servertime()) + ".html"

MergeFilePrint("s:\Docs\DB\LAATEST3.HTM","HTM","","",
	"LTTRName=" + DBName +
	";LTTRAdd1=" + DBAdd1 +
	";LTTRAdd2=" + DBAdd2 +
	";LTTRCity=" + DBCity +
	";LTTRDate=" + vDate +
	";LTTRClt=" + DBClt +
	";LTTRBal=$" + DBBal +
	";LTTRDBID=" + DBID,
	vOutputFile, 0)

vTitle = "TEST LAA 7"
vMessage = ""

n = @sendmail("mail.kingstondc.com",vTitle,"bwettlaufer@kingstondc.com",DBEmail,"","",vMessage,"bwettlaufer@kingstondc.com","SECRETPASSWORD",vOutputFile)
 

Hmmm ... writeln(n) returns 0.

Changing the attachment to another field, as "",vOutput1 still doesn't send the email, but I can see the output file created ... could this have to do with a server-side vs client-side interpretation where the file is, as S:\ is our mapped linux server on our Windows network, but the location would be .\Docs\DB as far as an internal server is concerned?

OK ...

n = @sendmail("mail.kingstondc.com",vTitle,"bwettlaufer@kingstondc.com","support@kin
gstondc.com","","",vMessage,"bwettlaufer@kingstondc.com","SECRETPASSWORD","")

- writeln returns 0
- email arrives

n = @sendmail("mail.kingstondc.com",vTitle,"bwettlaufer@kingstondc.com","support@kin
gstondc.com","","",vMessage,"bwettlaufer@kingstondc.com","SECRETPASSWORD","","")


- writeln returns 0
- email arrives

n = @sendmail("mail.kingstondc.com",vTitle,"bwettlaufer@kingstondc.com","support@kin
gstondc.com","","",vMessage,"bwettlaufer@kingstondc.com","SECRETPASSWORD","",vOu
tputFile)

- writeln returns -6
- no email arrives

I also tried using a non-binary attachment describing a local files on the server ".\sesame_allow.txt", "sesame_allow.txt", etc, still -6 and still no email arrives ...

What you need to do upon looking closer at the code is change your one line to

vOutputFile = "S:\Docs\DB\" + DBID + "-ELA-" + @num(@serverdate()) + "-" + @num(@servertime()) 

and your other line to

n = @sendmail("mail.kingstondc.com", vTitle, "bwettlaufer@kingstondc.com", "support@kingstondc.com", "", "", vMessage, "bwettlaufer@kingstondc.com", "SECRETPASSWORD", "", vOutputFile + ".htm") 

The reason for this is because MergeFilePrint() automatically adds an extension to the output file.

-Ray