|
midrange.com
Hi
We have a CL command that sends email with spool file attached as .WRI format.
When that email shows up, and the document attached (.WRI) is opened, it opens
in WordPad, opens fine and is well formatted, as shown below.
REPORT : LN145BR A-PRICE EXCEPTION REPORT
DATE: 7/18/05 TIME: 15:10:50
USER ID : FOR PROPS VS OMNI
PAGE: 1
FIN --------------- PROPS
----------------- OMNI
YEAR GRS1 TOY DESC QUOTA A-PRICE FOB-PRICE
DI-PRICE DDI-PRICE A-PRICE NEW
=================================================================================================================
2005 BOYS B0741 HM DRAGON WALKER .00
10.00 12.18 12.18 Y
2005 BOYS B0764 MX 4X4 HYDRO QUAD & ZIP .00
7.50 9.79 9.79 Y
2005 BOYS B1280 SPONGEBOB GIFT PACK .00
4.90 5.59 5.59 Y
2005 BOYS B1307 UNO ATTACK GAME (PDQ) Y 17.00 .00
.00 17.00 Y
2005 BOYS B1536 SPONGEBOB LG PLUSH .00
7.00 9.63 9.63 Y
2005 BOYS B1838 SUPER-BLAST HELICOPTER Y .00
13.82 17.15 17.15 Y
2005 BOYS B2069 HW MJ FLAMETHROWER ASST .00
10.36 13.15 13.15 Y
2005 BOYS B2104 SURP SPONGEBOB ASST .00
10.50 12.11 12.11 Y
2005 BOYS B2419 SPONGEBOB-24PC ASST Y 1.45 .00
.00 1.45 Y
2005 BOYS B2665 HW SKATE HEDZ ASST Y .00
2.49 2.87 2.87 Y
2005 BOYS B3268 SB SPONGEBOB ON BOARD .00
1.50 1.78 1.78 Y
Now, I am trying to attach the document as .XLS, as the upper management wants.
The email comes fine with .XLS document, but the format of the report is gone
for some part of the report, as shown below. I also tried to send it as .CSV
but no success.
REPORT : LN145BR A-PRICE EXCEPTION REPORT
DATE: 7/18/05 TIME: 14:42:05
USER ID : FOR PROPS VS OMNI
PAGE: 1
FIN --------------- PROPS
----------------- OMNI
YEAR GRS1 TOY DESC QUOTA A-PRICE FOB-PRICE
DI-PRICE DDI-PRICE A-PRICE NEW
=================================================================================================================
2005 BOYS B0741 HM DRAGON WALKER .00
10.00 12.18 12.18 Y
2005 BOYS B0764 MX 4X4 HYDRO QUAD & ZIP .00
7.50 9.79 9.79 Y
2005 BOYS B1280 SPONGEBOB GIFT PACK .00
4.90 5.59 5.59 Y
2005 BOYS B1307 UNO ATTACK GAME (PDQ) Y 17.00 .00
.00 17.00 Y
2005 BOYS B1536 SPONGEBOB LG PLUSH .00
7.00 9.63 9.63 Y
2005 BOYS B1838 SUPER-BLAST HELICOPTER Y .00
13.82 17.15 17.15 Y
2005 BOYS B2069 HW MJ FLAMETHROWER ASST .00
10.36 13.15 13.15 Y
Please advice.
Thanks in anticipation.
Amitava
--------------------------------------------------------
This message (including any attachments) is only for the use of the person(s)
for whom it is intended. It may contain Mattel confidential, proprietary and/or
trade secret information. If you are not the intended recipient, you should not
copy, distribute or use this information for any purpose, and you should delete
this message and inform the sender immediately.
As an Amazon Associate we earn from qualifying purchases.
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.
