Guest fmonroy Report post Posted 09/20/2006 08:25 AM Hello, I'm using the Send Email Module and it's working great send emails but I need to send the body as HTML instead of plain text. I didn't find any option to obtain this result. I'm wondering if it can be achieved using EmailQue.mdb. Any idea? Thanks in advance. Fidencio. Share this post Link to post
SupportTeam Report post Posted 09/20/2006 09:30 AM I'm wondering if it can be achieved using EmailQue.mdb. Any idea?Try doing this: 1. Stop VG. 2. Place attached .exe in your VG directory (backup the existing file). 3. Open EmailQue.mdb in MSAccess and add a column named HtmlFlag - make it an integer type column. Then add entries direct to EmailQue.mdb and set the HtmlFlag files to be a 1. 4. Remember to use HTML encoding when specifying the body of the message. 5. Let us know how you go with it. VgEmailSender_5.2.1.zip Share this post Link to post
Guest fmonroy Report post Posted 09/21/2006 07:48 AM Hello, It worked once, then I'm not sure what I changed so it isn't working anymore. I will continue testing it, and I found a little problem: the log generated by the new VgEmailSender.exe is created in the desktop. Thank you very much. Fidencio. Share this post Link to post
SupportTeam Report post Posted 09/21/2006 08:25 AM Please update with attached .exe This .exe should fix the logging problem Please post the traces from this new version (.ZIPed). VgEmailSender_5.2.3.zip Share this post Link to post
Guest fmonroy Report post Posted 10/04/2006 05:29 AM This is the history This is the script's statement that enqueues the message to be sent I did some changes to protect the innocent insert into MsgQue (ToAddress, ToName, ReturnAddress, ReturnName, CcAddress, CcName, BccAddress, BccName, ReplyAddress, MsgSubject, MsgMessage, MsgAttachment, MsgAttachmentDeleteAfterSend, gw1_SmtpServ, gw1_UseAuthentication, gw1_UsePopAuthentication, gw1_AuthUserName, gw1_AuthUserPassword, gw1_POP3Host, gw1_SMTPPort, gw2_SmtpServ, gw2_UseAuthentication, gw2_UsePopAuthentication, gw2_AuthUserName, gw2_AuthUserPassword, gw2_POP3Host, gw2_SMTPPort, SendTime, SendRetriesLeft, SendDelayBetweenRetries, HtmlFlag ) values ('some@one.com', 'Some One', 'myemail@ddress.com', 'My Name', null, null, null, null, null, 'Subject', '<html> <head> <title> XXXXXXXXX </title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style type="text" <!--.style1 {font-family: Verdana, Arial, Helvetica, sans-serif}--> </style> </head> <body>XXXXXXXXXXXXXXXXX</body> </html>', null, 0, 'SRVRNAME', 1, 0, 'USERNAME', 'WRONGPASSWORD', null, 0, null, 0, 0, null, null, null, 0, 0, 5, 10, 1 ) This is the log (I didn't change anything) 221338.13 0 eng prog start 22:13:38 03 Oct 221338.25 0 que found 1/1 221338.25 0 que current: ID=22 221338.25 0 que update ID=22to SendTime=0610032223 SendRetriesLeft=1 221338.28 0 smtp Status Connecting to SMTP Server (srv01)... 221338.34 0 smtp Status Initializing Communications... 221338.36 0 smtp Status Sending Login Authentication... 221338.38 0 smtp Status Host Login OK! 221338.38 0 smtp send start 221338.38 0 --------------------------------------------------- 221338.38 0 To:fidencio.monroy@gmail.com, Cc:, Bcc:, AsHTML=False 221338.38 0 --------------------------------------------------- 221338.38 0 Subject 221338.38 0 --------------------------------------------------- 221338.38 0 <html> <head> <title> XXXXXXXXX </title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style type="text" <!--.style1 {font-family: Verdana, Arial, Helvetica, sans-serif}--> </style> </head> <body>XXXXXXXXXXXXXXXXX</body> </html> 221338.38 0 --------------------------------------------------- 221338.38 0 smtp Status Sending Sender Information... 221338.38 0 smtp Progress 6% 221338.39 0 smtp Status Sending Recipient Information... 221338.39 0 smtp Progress 12% 221338.41 0 smtp Status Sending Message... 221338.41 0 smtp Progress 13% 221338.42 0 smtp Progress 100% 221338.44 0 smtp Progress 100% 221338.44 0 smtp Status Transmission Complete... 221338.44 0 smtp SendSuccesful 221338.44 0 que delete ID=22 221338.44 0 smtp send end 221338.44 0 smtp Status Closing Connection... 221338.45 0 eng send attempt 1 result = [success] 221338.56 0 eng prog end 22:13:38 03 Oct Note that AsHTML=False Basically I insert a record with a wrong password to open the table to see the record values. Then I change the password to the good one and then launch VgEmailSender.exe (provided in your last post). Then the message is sent and the log generated. I receive a plain text message. Any idea? Share this post Link to post
SupportTeam Report post Posted 10/04/2006 09:37 AM OK, one more time.... Please update with attached .exe and try again. VgEmailSender_5.2.4.zip Share this post Link to post
Guest fmonroy Report post Posted 10/05/2006 05:53 AM It's working great now, thanks a lot. At the log this part changed 224735.53 0 --------------------------------------------------- 224735.53 0 To:fidencio.monroy@gmail.com, Cc:, Bcc:, AsHTML=True 224735.53 0 --------------------------------------------------- Can I keep using it until an official release is generated? Share this post Link to post
SupportTeam Report post Posted 10/05/2006 07:08 AM Thanks for letting us know. We will include the VgEmailSender you are using in the next VGD distribution (v6.0.3168) onwards. Share this post Link to post
ktruk Report post Posted 10/06/2006 10:23 AM Hi, this looks great! Any chance that it won't work with the TAPI version? (Please don't forget that a lot of us are still happily using TAPI and intend to do so!) Thx. Share this post Link to post
SupportTeam Report post Posted 10/06/2006 11:36 AM You should be able to use the new VgEmailSender with the TAPI version as well. Make sure to: 3. Open EmailQue.mdb in MSAccess and add a column named HtmlFlag - make it an integer type column. Then add entries direct to EmailQue.mdb and set the HtmlFlag files to be a 1. Share this post Link to post
Guest dwells Report post Posted 10/28/2006 07:19 AM I think the default on the new Dialogic version is to not have the htmlFlag in the EmailQue.mdb, but the mailer tries to do an INSERT statement with it. This has the effect of breaking the mailer - which I was having problems with up until I looked in the logs to see the invalid INSERT statement and this topic mentioning it being put in. That should probably be fixed for future releases if it's not already done. Share this post Link to post
SupportTeam Report post Posted 10/29/2006 01:21 AM I think the default on the new Dialogic version is to not have the htmlFlag in the EmailQue.mdb, but the mailer tries to do an INSERT statement with it. Is it possible that you just have an old version of the EmailQue.mdb file on your system? Try stopping VG then deleting the EmailQue.mdb file and then starting VG again. You will see that the EmailQue.mdb file created will have the HtmlFlag column in the MsgQue table. The EmailQue.mdb is created by either VgMulti.exe or by VgEmailSender.exe. Have just confirmed that both the VgMulti.exe and VgEmailSender.exe distributed in current release create the EmailQue.mdb file with the HtmlFlag column in the MsgQue table. Share this post Link to post
