Using a preformated Report in a file

[BKtechie]

Hello all-
I am designing a program to create e-mail in Dbase 5. I want it to grab the contents of a report and put them into the e-mail file as text. Unfortunately, I can't find anything that will allow me to do this, short of gernerating the report to disk, grabbing the contents into a string, and putting the string into the new file. Does anyone know of a shortcut I could use? Thanks in advance.

 

[RRiley]

If you are use MSMail or Exchange you can do a DDE poke and execute command to create the Email message. Or you can do a DDE call to MS Word then use the Email command button in the MS Word Menu to issue an Email. The easist would be to connect to Word via DDE poke all the data into the text body then create a Macro in Word to email the word doc. From dbase do an execute() command for the Macro and let Word do the email for you. You can reuse the same Word doc for all your emails as long as you do a SaveAs execute to save the word doc as a different name, or use the Macro to save it for you after the email is complete. If you go to the microsoft website you can get some examples of Macros and VB examples of DDE calls to word and excel. The VB examples will not translate exactly but you will get the general idea.