× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. March 2006

Re: E-mailing Queries

We use Ops Nav for this purpose.
1. The EOM person generates various reports ... those that came with the applications software, our modifications, and query/400 listings. 2. That same person uses Ops/Nav to locate the reports, and copy them to a folder on PC, changing the name of the TXT file to something meaningful such as TOPIC and FISCAL DATE. Actually several PC folders, named after WHO to get the reports, and perhaps year. 
3. This TXT file is then attached to standard e-mail.

Problems:
* Some reports are 198 print positions (compressed) which is unfriendly to people with standard 8 1/2 x 11 PC printers, even doing landscape printing (massive wraparound). * An intermediate human step needed to get the TXT file into proportional print (so everything stays lined up nice) 

Thus some reports need to be modified to make them PC friendly.
Also, the end users of these reports often import them into Excel, which means they need to be made XL-friendly, meaning avoid having multiple vertical lines of different kinds of data in the same column, and minimize the page headers, sub-totals on the report being sent to XL. 
-
Al Macintyre
http://en.wikipedia.org/wiki/User:AlMac
BPCS/400 Computer Janitor ... see
http://radio.weblogs.com/0107846/stories/2002/11/08/bpcsDocSources.html
-

We have a large number of month-end reports that are produced by queries
which are printed and distributed each month. Is there a way to have these
e-mailed directly to the recipients without purchasing any additional
software? If software is necessary, is there anything that will do the trick
cheaply? Please be as detailed as time allows



John A Candidi

Rutgers Insurance Companies

IT Director - AS/400 Manager

856-779-2274

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.