Focal Point
[CLOSED] OWA ActiveSend 8.1.0

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8427017176

July 16, 2014, 04:52 PM
Jveselka
[CLOSED] OWA ActiveSend 8.1.0
The reports were built with DevStudio 764.

Anyone using Activesend to pass email address variables from webfocus report to OWA?

We have a report that lists an agents name and when the user clicks the name it brings up a blank email message and populates the email address and subject line with variables passed from the HTML page. It was working fine with XP and the old version of Activesend but now that we have moved to Win7 and Activesend 8.1.0 it has stopped working.

This works fine with regular Outlook but unfortunately we cannot provide Outlook to all our outside users.

Any help would be greatly appreciated. I am working with Messageware but they have yet to reply with any help.

Thanks
JV

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 8105m
Windows, All Outputs
July 21, 2014, 07:35 PM
<Kathryn Henning>
Hi JV,

Have you heard back from Messageware about this? I wasn't able to locate any information either internally or on the Web about this.

You mentioned that after moving to a different OS and version of Activesend, it stopped working. Does the blank email message come up at all, or does it come up and then fail to populate?

Thanks and regards,

Kathryn
July 22, 2014, 03:15 PM
Jveselka
They keep sending me examples with hardcode in the link, It works fine like that but that is not the issue.

Yes the message comes up but it does not populate the email address or the subject.

Thanks


WebFOCUS 8105m
Windows, All Outputs
July 23, 2014, 07:39 PM
<Kathryn Henning>
Hi JV,

Would you happen to have any documentation on the old version of Activesend where it describes how they're reading the variables being passed in to populate the email address and subject?

Thanks and regards,

Kathryn
July 29, 2014, 04:24 PM
Jveselka
I am not sure but good idea, I will see what we have.

Thanks
JV


WebFOCUS 8105m
Windows, All Outputs
July 29, 2014, 04:31 PM
Jveselka
Oh and this process works fine from FireFox.

We have updated to IE 10 but I did put IE 8 back on the test machine with no luck.
Thanks
JV


WebFOCUS 8105m
Windows, All Outputs
July 29, 2014, 04:42 PM
J
If you posted the html/fex code that would be helpful as well...


WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs
July 29, 2014, 04:42 PM
Jveselka
Sorry and the version we are using now is 10.5.4. My laptop has not been updated. We also went to Exchange 2013 which may also have something to do with it.

Thanks
JV


WebFOCUS 8105m
Windows, All Outputs
July 31, 2014, 01:02 PM
Jveselka
This code is built for a stored procedure that is passed to us. See javascript in style code below.

 
-SET &ECHO=ALL;
SET EMPTYREPORT = ON
SET ALL = PASS
SET NODATA='';
-INCLUDE routines/setmssparms.fex
-INCLUDE routines/extract_session_tscomid.fex
APP HOLD &SYSAPATH
-*SET &PolicyNumber = &txtPolNum;
-TYPE &PolicyNumber
SQL SQLMSS SET SERVER &MSSSPTAB1;
SQL SQLMSS EX [dbo].[rptCurrentQueuebyPolicyNumber] '&PolicyNumber';
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS &TSCOMID FORMAT ALPHA
END
DEFINE FILE &TSCOMID
TOT/I10=IF DocType EQ LAST DocType THEN 1 ELSE 1;
NEW_EMAIL/A50=IF EmailAddress EQ ' ' THEN 'N/A' ELSE EmailAddress;
NEW_DOCTP_DESC/A500='Policy '| PolicyNumber ||(', Insured Name: '| InsuredName);
END
TABLE FILE &TSCOMID
PRINT PolicyNumber
 ProcessName
 ProcessID
 TakenBy
 AssignedTo
 StepDescription
 Category
 DocType
 DaysInQueue
NEW_EMAIL NOPRINT
NEW_DOCTP_DESC NOPRINT
-*NEW_FULLNAME
TOT NOPRINT
-*WHERE PolicyNumber EQ '&PolicyNumber';
ON TABLE SUBHEAD
"Current Queue by Policy Number"
ON TABLE SUBFOOT
"Generated on &DATEMDYY"
"Total Number of Jobs <TOT.TOT"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
TYPE=DATA,
     COLUMN=N9,
     JUSTIFY=CENTER,
$
TYPE=DATA,
     COLUMN=N5,
     WHEN=N7 NE 'N/A',
     JAVASCRIPT=fnMail(NEW_EMAIL NEW_DOCTP_DESC),
$
ENDSTYLE
END
-RUN
-HTMLFORM BEGIN
<SCRIPT LANGUAGE=JAVASCRIPT>
function fnMail(Email,Subject)
{
window.location = 'mailto: ' + Email + '?Subject=' + Subject;
}
</SCRIPT>
-IF &LINES NE 0 THEN GOTO ENDING;
-HTMLFORM BEGIN
<br>
<font face="arial,helvetica,sans-serif">No records found.</font><br></font>
-HTMLFORM END
-ENDING
 



WebFOCUS 8105m
Windows, All Outputs
July 31, 2014, 01:03 PM
Jveselka
Thanks Smiler


WebFOCUS 8105m
Windows, All Outputs