Re: SQR Email and Excel

[Franck Masson <franck.masson@BRIO.COM>]

In this case i will recommande to write an sqr code that produce your excel
document using the sylk format.
It is an ascii format that you can easely produce with SQR.
to have an idea of how is structured sylk format
open excel create a document and save it as sylk format.
To create this sylk output in sqr use excell to produce the excell layout
and use sqr to read file and replace/add lines

Franck,

-----Original Message-----
From: tsenuwani Makhari [mailto:tshenuwani@INFOWAVE.CO.ZA]
Sent: mardi 15 janvier 2002 15:55
To: SQR-USERS@list.iex.net
Subject: SQR Email and Excel


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.