Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Zip reports
- Thread starter asm338s
- Start date
Do you mean that you want to automate the process? If you just need to send a particular report to someone, say as a zipped e-mail attachment, then print the report to a file and then zip the file. I know my wife has to send large reports out of state and prints FoxPro reports as .pdf files, zips them and then emails them to the people who have to use them.
Dave Dardinger
Dave Dardinger
- Thread starter
- #3
I would like to print them to a file and then zip the file, but some of my reports are in landscape format and I can't view them correctly in .txt format. Any solution for this?
In other case I convert some of my other reports to word document and I would like to give the users an option to zip them and then e-mail them?
Thanks
In other case I convert some of my other reports to word document and I would like to give the users an option to zip them and then e-mail them?
Thanks
I don't understand what's the problem with .txt format? Is it that in the particular form of .txt file you're getting it has carriage return / linefeeds at the end of each line insted of each paragraph? If so, you can probably fix it by writing a little program to use subtran() to get rid of the extras.
At any rate, if you'd post whatever code you're using to produce your report output we can probably get it to work more like what you'd like.
Dave Dardinger
At any rate, if you'd post whatever code you're using to produce your report output we can probably get it to work more like what you'd like.
Dave Dardinger
- Thread starter
- #5
Hi Dave:
My program creates 10 reports. 4 out of 10 are in landscape format. Notepad doesn't show these reports correctly. The spacing between columns is reduced, and all data comes jumbled up. Rest of the reports i have as both .txt and .doc files are in c:\myApp folder. Now I want to take it from there and zip those files and may be e-mail them. Sorry if I didn't made myself clear earlier.
Thanks for taking interest in my problem.
asm338s
My program creates 10 reports. 4 out of 10 are in landscape format. Notepad doesn't show these reports correctly. The spacing between columns is reduced, and all data comes jumbled up. Rest of the reports i have as both .txt and .doc files are in c:\myApp folder. Now I want to take it from there and zip those files and may be e-mail them. Sorry if I didn't made myself clear earlier.
Thanks for taking interest in my problem.
asm338s
Hi my friend
It seems to be a 3 levels job
1- Convert the FRX to DOC (I will assume you already get this one to work)
2- Zip the file
3- Send it E-mail
Regarding step 2, go to this Dll do fantastic job in terms of both Automation and Compression rate. It comes with Fox example so you can get started fast. Make sure to register the Library if you like it, you just have a 30 free trail.
To solve the 3rd and the last one which is send E-mail
1- If you use Outlook, just type Outlook in the search engine of this site. A lot of folks and my self handled this subject b4.
2- If you don't use Outlook or you don't want to use for what ever reason you can visit Rick Strahl’s web site
and download his free class wwIPStuff
One of the methods can allow you to send email using MAPI directly.
Hope this will help
Walid Magd
Engwam@Hotmail.com
It seems to be a 3 levels job
1- Convert the FRX to DOC (I will assume you already get this one to work)
2- Zip the file
3- Send it E-mail
Regarding step 2, go to this Dll do fantastic job in terms of both Automation and Compression rate. It comes with Fox example so you can get started fast. Make sure to register the Library if you like it, you just have a 30 free trail.
To solve the 3rd and the last one which is send E-mail
1- If you use Outlook, just type Outlook in the search engine of this site. A lot of folks and my self handled this subject b4.
2- If you don't use Outlook or you don't want to use for what ever reason you can visit Rick Strahl’s web site
and download his free class wwIPStuff
One of the methods can allow you to send email using MAPI directly.
Hope this will help
Walid Magd
Engwam@Hotmail.com
- Status
Similar threads
- Locked
- Question