Send a query by Email, not as a icon but expanded

[Wayne Beck]

Can somebody please help. I would like to send a query by e-mail to a number of users. I dont want it sent as an icon because i believe not everyone would take the time to double click the icon to view it in Excel. What i would like to do is Paste it into the email like Excel does, ie if I select and copy 10 rows of data this is then pasted onto the email and all the data is instantly viewable.
Thanks in advance for any help that you can give.

Regards

Wayne

 

[Atomic Shrimp]

If you're using A97 and you send it in HTML format and leave the message text argument blank, it *should* appear as if it's the body of the email (it is still actually an attachment, but many email client programs are smart enough to open it)

However, this doesn't seem to work in A2K.

also, be warned, I've had problems printing received HTML format emails - I just get a blank page, plus how it looks at the other end is always going to be client-dependant.

Mike

 

[Wayne Beck]

Thanks for your reply Mike. Unfortunately, I'm using A2K and the email also needs to be printed off at the receiving end.

Thanks again.

Wayne

 

[Neal]

I have used a convoluted method to do something similar with a Word document. I output the report as rft, open the file in Word and execute a macro that copies the text into clipboard. Then I close the file and Word, open Outlook and use SendKeys to paste the text into the body. I suspect you could do the same with Excel. The SendKeys method isn't 100% reliable. Some users have to manually paste the text into the e-mail.
There is a way to work with clipboard by calling API functions, but it is way over my head.