Focal Point
[CLOSED] How to send a multipart/mixed email from a fex?

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

August 18, 2011, 10:23 AM
jfr99
[CLOSED] How to send a multipart/mixed email from a fex?
Hi All,

I would like to be able to send a multipart email from within a fex. This would mean having text (as well as amper variable data) in the body of the email and also be able to send attachment(s) along with this same email.

I currently do this using Perl in my fexs, but, we are upgrading from 7.1.x to 7.7.x and the admins have decided Perl will not be installed on our new environment.

So.....

I am looking for alternate ways to send an email notification with or without one or more attachments.

I have been trying out the EDAMAIL option, but can only seem to get that to work with sending one piece of information (either one attachment or one inline piece of data).

I would rather be able to do this from a fex instead of using reportcaster.

If you have done anything like this, please let me know.

Thanks
Jim

This message has been edited. Last edited by: Kerry,


WebFocus 8.201M, Windows, App Studio
August 18, 2011, 02:54 PM
ABT
have you tried writing out values from one hold to DM variables and referring to them as amper vars? not exactly in line data grid with attachment, but maybe this is what you're looking for.


------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro
August 18, 2011, 05:49 PM
Waz
We are on Unix, and have been using mailx.

Perhaps there is an equivalent in Windows.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

August 19, 2011, 09:59 AM
jfr99
I would like to use EDAMAIL. If I could just include some text in the body and then attach a file, I would be good to go. Sounds pretty basic. Has anybody done this? Is there some documentation about EDAMAIL?

Thanks
Jim


WebFocus 8.201M, Windows, App Studio
August 19, 2011, 03:32 PM
ABT
This is as close as you'll get: http://forums.informationbuild...1057331/m/2207017106

- ABT


------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro
August 21, 2011, 06:49 PM
Waz
You can createa multipart email, but you will have to create the email structure yourself.

HEre is a simple way to have text as the body, and an attachment, but it relies on having UUENCODE.

FILEDEF MAILFILE DISK mailfile.txt

-RUN

-WRITE MAILFILE This is the body of the email
-WRITE MAILFILE  
-WRITE MAILFILE Attached is the report.
-WRITE MAILFILE  

TABLE FILE CAR
PRINT COUNTRY
ON TABLE HOLD AS MAILREPT FORMAT PDF
END

-RUN

! "C:\Program Files\GnuWin32\bin\uuencode" mailrept.pdf My_Report.PDF >> mailfile.txt

-RUN

EX EDAMAIL {email to},{email from},EDAMAIL test,,TXT,mailfile



Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!