Hi Raido, We accomplish this by using the remedy email engine, Crystal Enterprise 9 and an ASP page. The result is the user clicks a button and an email window opens with the PDF already attached to the attachment pool. The user can then edit the body of the email and click send.
To do this, our workflow first calls the asp page with an active link/OLE action. The ASP page runs the report, converts it to pdf and saves it to a network location. The asp/ie browser page is invisible to users. After the pdf is stored to a network location, we have workflow that grabs the pdf and attaches it to an attachment pool. The user can then add any comments to the body of the email and click send (with pdf attached). Contact me off-line if you'd like more info. Thanks, Karee [EMAIL PROTECTED] -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Raido Oja Sent: Thursday, August 24, 2006 11:19 AM To: [email protected] Subject: Re: pdf to email Thanks for the feedback, but likewise - I'm not an OLE guru.. and we don't use Crystal. I'm abandoning the idea of automating the exact scenario for now. Not long ago there was a thread named "automatically generate email with report included". Thomas Bean's solution should work for my case as well in its general idea. Raido Oja [EMAIL PROTECTED] patrick zandi wrote: > There might be a way threw Crystal Reports.. there is an Export > function in the viewer to a PDF format.. I would think.. that there > might be a Way just to make the report a PDF and save it to a file.. > Never every tried that .. but it might be worth looking at. OR I > recently saw somewhere .. Someone had an api with a built in PDF > functionality ? is PDF open source now ? > > On 8/24/06, Michiel Beijen <[EMAIL PROTECTED]> wrote: >> ** I guess you could the File > Pint bit using OLE automation. Macros >> only >> do searches or data maniputation, not printing afaik. >> I am not an OLE guru so I can not advice you how this should be done, >> but >> you might have access to a tech with OLE skills yourself or try some >> googling... >> -- >> Michiel >> >> On 8/24/06, Raido Oja <[EMAIL PROTECTED]> wrote: >> > Hi, >> > >> > At present I have the following scenario: >> > - user opens a display only form with some formatted character fields >> > - prints to a virtual pdf printer (using file > print) >> > - sends the .pdf via his default mail program as an attachment >> > >> > I need to automate that process. I can save the pdf to the email >> > messages form as an attachment using run process commands in an AL. >> The >> > tricky part for me is actually generating the pdf. Can I do the >> 'file > >> > print' command in a macro ? (having the printer and file name as >> > parameters). This would be the first time for me to work with >> macros so >> > any help is greatly appreciated. I'm also having a hard time finding >> > material on macros, there's not much in Remedy's docs. Am I even on >> the >> > right track with this solution ? >> > >> > Raido Oja >> > [EMAIL PROTECTED] >> > >> > >> ________________________________________________________________________ _______ >> >> > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org >> > >> >> __20060125_______________________This posting was submitted >> with HTML in it___ > > ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
