Re: SQR Email and Excel

[Arun Kumar <arunkumar13@YAHOO.COM>]

Hi,
First the sqr can only write ASCII file which you
cannot use excel to open unless you are creating using
SLK technique.
If you are using slk technique then you can set the
width of any column.
ex.,

write 5 from 'F;W1 6 12'
Here the width of the columns 1 to 6 being set to 12
units in excel

Hope this helps
Arun
--- tsenuwani Makhari <tshenuwani@INFOWAVE.CO.ZA>
wrote:
> Hi Guys !
>
> Problem Detail  :
> We need to send a form through E-Mail for several
> departments to fill in
> their part of the electronic form.
> The pre-filled (heading) part of this form are found
> within the database. So
> the form is written using SQR. Our users also need
> an option to open this
> form using MS Excell and also normal Email.  ( When
> they user MS Excell ,
> they want the form to open with the right column
> sizes[width]. )
>
> eg.
>
__________________________________________________________
> Order No: 18NH 12312      Line Number : 123
> Date : 2001 - 12 - 14
> MM Dept |        Finance  Dept  |   ADMIN Dept
> Product Codes   |      Product Price/Qty        |
> Product CHG Number
> _____________   |____________________
> |________________________
> _____________   |____________________
> |________________________
> _____________   |____________________
> |________________________
> _____________   |____________________
> |________________________
> _____________   |____________________
> |________________________
> _____________   |____________________
> |________________________
> _____________   |____________________
> |________________________
>
>
> Please help urgently . This is a crisis.


__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/