Re: Formatting an EXCEL Worksheet Generated From The 400

[pnelson@xxxxxxxxxx]

How about the products from ASC?  www.asc-iseries.com  SEQUEL/ViewPoint 
gives you the ability to email Excel spreadsheets to recipients. You can 
even set things up in a script or a CL program so that these transmissions 
take place unattended. 

I've got a client who substantially reduced his A/R days by having the 
system email each sales rep an aged trial balance spreadsheet every Friday 
night during the weekly processing. The boss tied the commission plan in 
part to the age of the customer's balance. The second week the new 
commission plan was in place, the payment checks started flowing in from 
previously delinquent customers.....  :-))

The whole routine cost them about 2 hours of my time.

Paul Nelson
Arbor Solutions, Inc.
708-670-6978  Cell
pnelson@xxxxxxxxxx

"Courage is contagious. When a brave man takes a stand, the spines of 
others are often stiffened." ~~ Billy Graham




"Rick Rayburn" <the400man@xxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
02/06/2004 04:33 PM
Please respond to Midrange Systems Technical Discussion

 
        To:     midrange-l@xxxxxxxxxxxx
        cc: 
        Subject:        Formatting an EXCEL Worksheet Generated From The 400


Specifically, we are currently using the KEYES E-Mail/Fax Software to 
integrate fax and e-mail server functions on our 170 box.

A CSV - formatted file is created from data requested by our users and 
then 
is e-mailed from the 400, through the KEYES software, with it's 
destination 
being EXCEL.

The problem we are experiencing occurs within EXCEL itself. Because of 
varying field sizes, which cannot be altered, when the CSV file is opened, 

multiple formatting issues occur...#'s representing some date fields, 
numeric fields not zero suppressing, columns showing as truncated although 

when you click on them the data is fine and other stuff of this ilk.

I know it is easy to re-format the information within EXCEL but we would 
like the output to arrive in a pre-formatted condition so the very-end 
user 
does not have any over-head.

But how to do this? I know there are software packages out there where you 

can design a pre-defined format and then translate spool files into them 
but 
I am not very familiar with this arena. In addition, we cannot have manual 

intervention during this process. Run a batch report, load a file with 
data, 
send it through KEYES and mail out as CSV...no middle steps from 
humans....however automation between the mailing out and the end-user 
opening it up in EXCEL would be great!!

Any ideas people?

Thanks much.

Rick Rayburn
NYC

_________________________________________________________________
Plan your next US getaway to one of the super destinations here. 
http://special.msn.com/local/hotdestinations.armx

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.