Making a Report that go straight to email

[Joseph31]

Can anyone tell me how I can take an existing report (Letter) and make it open and paste into an email so I can send it.

Thank you

[MarkWilson]

Joseph31,

You can use the Send Mail [] script step

or

a better solution may be

use the Open URL [] script step and create calculation field (text)

cEmail =

"mailto:" & EmailField &

"&cc=" & ccField &

"&bcc=" & bccField &

"?subject=" & SubjectField &

"&body=" & "Hi " & NameFirst "," &

"%0D" & "%0D" &

Substitute( Text , "

[Joseph31]

Cool thanks...is there a way to put a report on the email also???

[Reed]

You could just summarize your report into a text field using scripting and calculations and place the contents into the body of the email. If you actually want a report that retains the formatting of your layout, your best bet is probably to use adobe acrobat (or equivalent) to print the report to a pdf file and then use the send mail script step to attach the file to your email. I don't think you can use the open URL script step to attach a file automatically, but somebody correct me if I'm wrong on that.

[MarkWilson]

Reed is correct. Microsoft's MSDN info on the mailto protocol does not give an attachment option. I have feverishly searched the Internet for a solution, but to no avail. I have only seen suggestions that file paths can be sent to allow remote opening or the file path on the recipients machine if the file already exists.

A plug-in or the Send Mail [ ] script steps are your attachment options.

[Joseph31]

wow ok thanks guys...I will keep dreaming...: